Pallavi,
[Please keep replies on-list. It helps other people, my mail rules keep you
separated from paying clients, and the list archives are complete]
> actually i created a new file by vim & then did cut & paste .
=therein lies the problem. If you compare the listing below with the
expected out
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;
> +
