开发者

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).

mysql import vertical csv data

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜