Dear mysql people: I am trying set up a dataset in mysql version 3.23.42 on a Mac OS X Server v10.2. When I use the "load data" statement, only one record gets read into the table. If I edit the file and remove the top record, then when I give another "load data" command, mysql reads the new top line of the file.
mysql> load data infile "staff_t3.txt" into table staff01; Query OK, 1 row affected (0.00 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 1 I'm typing the commands from a shell on the server with su as root. The text file in located in /sw/var/mysql/facstaff where facstaff is the name of the database. The file "staff_t3.txt" is a tab delimited text file with one record per line. Why doesn't mysql read the whole file? and how can I find the "Warnings: 1"? Please reply directly to my email. [EMAIL PROTECTED] Thank You, Jimi Oleksiak --------------------------------------------------------------------- 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