MySQL Forums
Forum List  »  Chinese

求助:如何通过命令行把.cvs或者.txt文件import 到MySQL中去
Posted by: yongming li
Date: September 08, 2007 07:49AM

大家好,

大现在想把.cvs或者.txt文件通过命令行import 到MySQL中去. 按照MySQL Tutorial的命令(如下所示)我运行多次。系统总是提示有Error(文件没有找到). 不知道那里错了,还是命令用的不对。 急,希望有人能帮我。先谢谢了。

mysql-> load data infile 'C:\record_woodbox.cvs' into table record_woodbox
-> fields terminated by ','
-> lines terminated by '\n';
'record_woodbox.cvs' not found (Errcode:22)
mysql->


fanxin

Options: ReplyQuote


Subject
Views
Written By
Posted
求助:如何通过命令行把.cvs或者.txt文件import 到MySQL中去
15316
September 08, 2007 07:49AM
7320
September 11, 2007 11:20AM
6996
September 13, 2007 01:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.