"Scott Dunn" <[EMAIL PROTECTED]> wrote:
> I accidentally crashed 1 of my tables. So I deleted everything in the
table
> and tried to reload the data into the table and now I get this error:
> Query OK, 1 row affected (0.02 sec)
> Records: 1 Deleted: 0 Skipped: 0 Warnings: 5
>
> I have a total of 1901 records in this txt file. I puts the first record
in
> and forgets the rest. What are some things that I can look for to see what
> is wrong. Could it be that I made all fields not null and there are some
> empty? If you need more info just ask!!!
Why not send the output of the following to the list:
DESCRIBE table_name_here;
SHOW INDEX FROM table_name_here;
First 5 records from the text file.
Command being used to import from the text file.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
---------------------------------------------------------------------
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