求助:如何通过命令行把.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
Subject
Views
Written By
Posted
求助:如何通过命令行把.cvs或者.txt文件import 到MySQL中去
16306
September 08, 2007 07:49AM
8233
September 10, 2007 07:28PM
7460
September 11, 2007 11:20AM
7108
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.