c:\temp -> c:\\temp
-bill
Lisa He wrote:
Hi,
I have a question with regards to Load data infile...
I have a .txt file containging only path names e.g " C:\temp " in the bodytext. this file is imported into the DB using load data infile.
However, when i do a "select * " on that table which i've just imported, the result looks like this:
C:temp\r
so i assume what has happened is that when this file is imported into MYSQL, MYSQL treats any forward-slashes as codes. i.e. \t , \n , \r etc
I have tried to put double quotes around the pathnames but it doesn't help.
What should i do so that the path name does not get truncated??
thanks, i'd appreciate the help
regards,
Lisa
_________________________________________________________________
Fynda på nätet! Handla på MSN Shopping http://www.msn.se/shopping
---------------------------------------------------------------------
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