Brian,

My original file:

mysql> select * from pet; +-------+---------+------------+------+ | name | address | birth | sex | +-------+---------+------------+------+ | Marie | Manila | 0000-00-00 | f | | Lei | Manila | 0000-00-00 | m | +-------+---------+------------+------+

when i use "LOCAL DATA INFILE"

load data infile "test.txt" replace into table pet; Query OK, 6 rows affected (0.03 sec) Records: 6 Deleted: 0 Skipped: 0 Warnings: 7

select * from pet; +---------+---------+------------+------+ | name | address | birth | sex | +---------+---------+------------+------+ | Marie | Manila | 2000-12-24 | f | | Lei | Manila | 0000-00-00 | m | | name | | 0000-00-00 | | | Marie | | 2000-12-24 | | | Lai | | 0000-00-00 | | | Clay | | 0000-00-00 | | | Danny | | 0000-00-00 | 19 | | Maribel | | 0000-00-00 | | +---------+---------+------------+------+ 8 rows in set (0.00 sec)

QUESTIONS:

1. why instead replace name Marie it creates another marie, 2. and also the word name....... its appears again .... -:/ 3. Also the birthday why it appears as 0000-00-00...... 3. All i want is to load my new file into my existing file and if theres a the same name it will update/replace the file........

Thanks in advance........ Hope u can help me....... pls....... :-)

lea