2 messages in com.mysql.lists.win32Re: Strange Command on Load Data!
FromSent OnAttachments
Jack26 Apr 2002 00:22 
Fredrick Bartlett26 Apr 2002 08:08 
Subject:Re: Strange Command on Load Data!
From:Fredrick Bartlett (palm@earthlink.net)
Date:04/26/2002 08:08:16 AM
List:com.mysql.lists.win32

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" <nedc@nedcor.com.hk> To: <mys@lists.mysql.com>; <win@lists.mysql.com> 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 nedc@nedcor.com.hk

--------------------------------------------------------------------- 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-palmtreeFRB=eart@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php