Are you trying to load data FROM a text file, or are you trying to load data INTO a textfile? You said "I just created a database and tried to LOAD 1 line of data from a text file." but then you stated "i need to INTO OUTFILE" ...
If you wanna load data from a text file into a table, look at: http://www.mysql.com/doc/L/O/LOAD_DATA.html If you wanna load data into a text file, look at: http://www.mysql.com/doc/S/E/SELECT.html Gurhan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 3:34 PM To: [EMAIL PROTECTED] Subject: newbie help I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd --------------------------------------------------------------------- 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