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
