mysqlimport query

[santhanalakshmi]

hi,

can you give me the mysqlimport query ?


i tried with this

C:\xampp\mysql\bin>mysqlimport -u root -p  --fields-terminated-by=","
 --lines-terminated-by="\r\n" test C:/lists.txt;
Enter password:
mysqlimport: Error: 2, File 'C:\lists.txt;' not found (Errcode: 2), when using t
able: lists

i dont know why i am facing this error ? i have the same name as of table name.my file is in c drive .


if i copy the same file and pasted in the bin folder means its working....

C:\xampp\mysql\bin>mysqlimport -u root -p --fields-terminated-by=","
--lines-terminated-by="\r\n" test lists.txt

[chathura86]

are you sure that C:/lists.txt path is correct

try something like this
C:\lists.txt

Regards

[rythmic]

You are on a windows system.. so how about using software with a neat interface.

such as mysql administrator from mysql.found here:
http://dev.mysql.com/downloads/gui-tools/5.0.html