I have csv data in this format:

id   fieldname fieldvalue
--   --------- ----------
1    fieldA    A1
1    fieldB    B1
2    fieldA    A2
2    fieldA    B2

If I upload this to MySQL, how can I convert the data easily to the conventional "relational format":

id   columnA   columnB
--   -------   -------
1    A1        B1
2    A2        B2

Otherwise how can I query data in this format? I’d like to be able to do things like SELECT * FROM table_name WHERE x=y OR a=b AND t=w. Are there database software that specifically deal with this sort of data?

Lastly, is there a systematic name for such data representation? eg. we have "relational" data, XML data. I remember reading on the .rdf format standard and recall that it does resemble that, but I am not sure if there's a more general name.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.