Pallavi, > 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?
Compare your answer against the tutorial provided: 3.3.3 Loading Data into a Table. Note the differences! Now you see the reason(s) for warnings. Please check your input data. Did you download the sample data files, create your own, or attempt a cut-and-paste. May I recommend the former. Regards, =dn --------------------------------------------------------------------- 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
