Hello, Jack! Special characters have a functional meaning to MySQL(and compilers as well). It is necessary to escape them for any other purpose than the host enviroments function. In MySQL \ is an escape character therefore, if you need to pass \ as a string you must escape it \\ . There is a discussion on this in the MySQL doc's.
Fredrick ----- Original Message ----- From: "Jack" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 26, 2002 8:22 AM Subject: Strange Command on Load Data! > 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 > --------------------------------------------------------------------- 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