load data worked with warnings

[Pallavi Arun Patil]

mysql> load data infile "pet.txt" into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql> load data infile "pet.txt" into table pet;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 4

mysql> select * from pet;
+--------------+--------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+--------------+--------+---------+------+------------+------------+
| Fluffy | Harold | cat | f | 1993-02-04 | NULL |
| Claws | Gwen | cat | m | 1994-03-17 | NULL |
| Buffy | Harold | dog | f | 1989-05-13 | NULL |
| Fang | Benny | dog | m | 1990-08-27 | NULL |
| Bowser | Diane | dog | m | 1998-08-31 | 1995-07-29 |
| Chirpy Gwen | bird | f | 1 | 0000-00-00 | NULL |
| Whistler | Gwen | bird | 1 | NULL | NULL |
| Slim | Benny | snake | m | 1996-04-29 | NULL |
+--------------+--------+---------+------+------------+------------+
8 rows in set (0.00 sec)

but what for but what for 4 warnings?
does it for some internal reason?

pallavi

---------------------------------------------------------------------
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