470,613 Members | 2,315 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

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

Mar 15 '06 #1
1 1484
al*******@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
Mar 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Reply via newsgroup | last post: by
7 posts views Thread by Leif K-Brooks | last post: by
3 posts views Thread by USI Newsgroups | last post: by
1 post views Thread by julian_m | last post: by
10 posts views Thread by art | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.