Jack,
Friday, April 26, 2002, 10:22:52 AM, you wrote:
J> I had use the Load Data Command to import my CSV file from my client side
J> of pc to the Mysql database which located in Server side.
J> The command i type is follow:
J> Load Data local infile 'c:\\Doucments and
J> Settings\\jack\\Desktop\\Web\\test\\hkd_rate.csv' into table hkd_deposit1
J> fields terminated by ","
J> Then the data inside this file will be import to the table (hkd_deposit1).
J> but the strange thing is
J> i know the command should be type in this way:
J> Load Data local infile 'c:\Doucments and
J> Settings\jack\Desktop\Web\test\hkd_rate.csv' into table hkd_deposit1 fields
J> terminated by ","
J> so why i need to put "\\" instead of "\" to get the work done, is there
J> anything in mysql i had setted wrong?
'\' is an escape character in MySQL and it is also used to separate
pathname components on Windows. so, you should use '\\' or '/' instead
of '\'.
Look at:
http://www.mysql.com/doc/W/i/Windows_vs_Unix.html
J> Thx a lot!
J> Jack
J> [EMAIL PROTECTED]
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
