Hi all, I'm doing a quick and dirty import/export thingy, using the command LOAD DATA INFILE ... All fields in the table are of the type TEXT. and the text file (2be imported) is comma seperated and fields are double quote enclosed.
Without use of the 'ENCLOSED BY' clause field data looks like \"foobar\" and with the 'ENCLOSED BY' clause they still do except the first field. (Even when escaping the chars with a backslash) Any clue? ... thanx a lot. Oh and is there a place where I can find the content of the warnings For the details, here is the command mysql> LOAD DATA INFILE '/home/gerard/files/mysql/adress/jpilot.cvs' INTO TABLE adresses FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES; Query OK, 251 rows affected (0.06 sec) Records: 251 Deleted: 0 Skipped: 0 Warnings: 794 -- "Who cares if it doesn't do anything? It was made with our new Triple-Iso-Bifurcated-Krypton-Gate-MOS process ..." GrtzG ~ :wq! --------------------------------------------------------------------- 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
