mysql import vertical csv data
I have a spreadsheet that is currently formatted improperly for a mysql import. The data are organized by c开发者_如何转开发olumn rather than by row. So, the first column has the field names, the second column contains record 1, and so on.
Is it possible for mysql to understand this data? If not, any ideas on how to import these data besides redoing the spreadsheet?
The data are currently in a google doc.
Edit: I write php, if that helps the matter at all, though I was planning on importing using sequel pro.
You tagged this "import-from-excel"; you could simply select the data in excel, copy, and then use "paste special" to transpose the data (it's a checkbox near the bottom of the "paste special" window; see image).
精彩评论