Dear all I had use the Load Data Command to import my CSV file from my client side of pc to the Mysql database which located in Server side. The command i type is follow: Load Data local infile 'c:\\Doucments and Settings\\jack\\Desktop\\Web\\test\\hkd_rate.csv' into table hkd_deposit1 fields terminated by ","
Then the data inside this file will be import to the table (hkd_deposit1). but the strange thing is i know the command should be type in this way: Load Data local infile 'c:\Doucments and Settings\jack\Desktop\Web\test\hkd_rate.csv' into table hkd_deposit1 fields terminated by "," so why i need to put "\\" instead of "\" to get the work done, is there anything in mysql i had setted wrong? Thx a lot! Jack [EMAIL PROTECTED] --------------------------------------------------------------------- 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