更新时间:2022-10-14 21:04:24
将其导出为一些文本格式。最简单的可能是制表符分隔的版本,但CSV也可以正常工作。
使用加载数据功能。请参阅 http://dev.mysql.com/doc/refman/ 5.1 / en / load-data.html
查看页面的一半,因为它将为标签分隔数据提供一个很好的例子:
由'\t'终止的字段''ESCAPED BY'\'
检查你的数据。有时引用或转义有问题,您需要调整源代码,导入命令 - 或者可能通过SQL进行后处理更容易。
Can any one explain how to import a Microsoft Excel file in to a MySQL database?
For example, my Excel table looks like this:
Country | Amount | Qty
----------------------------------
America | 93 | 0.60
Greece | 9377 | 0.80
Australia | 9375 | 0.80
Thanks in Advance.
Fero
Export it into some text format. The easiest will probably be a tab-delimited version, but CSV can work as well.
Use the load data capability. See http://dev.mysql.com/doc/refman/5.1/en/load-data.html
Look half way down the page, as it will gives a good example for tab separated data:
FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\'
Check your data. Sometimes quoting or escaping has problems, and you need to adjust your source, import command-- or it may just be easier to post-process via SQL.