easy way to enter 20000 records to Mysql db

Hi I'm looking for the easy way to enter a lot of information to Mysql
Db
for me the best way is like in access you just paste the buffer (from
excel) to the table you selected and it does it.

Please help.

Thanks,
Alexander

Re: easy way to enter 20000 records to Mysql db

alkazakov@gmail.com wrote:

> Hi I'm looking for the easy way to enter a lot of information to Mysql
> Db
> for me the best way is like in access you just paste the buffer (from
> excel) to the table you selected and it does it.

> Please help.

> Thanks,
> Alexander


Export the data to a CSV file and look at the docs for LOAD FILE

http://dev.mysql.com/doc/refman/4.1/en/load-data.html