Forum Moderators: coopster

Message Too Old, No Replies

Howto Convert .csv to .sql for upload to mysql

         

erikcw

11:07 pm on Jun 17, 2004 (gmt 0)

10+ Year Member



I have several databases that need to be uploaded to mysql. The data is currently in .csv format. I need a tool convert this csv file into a mysql dump .sql file. (I will then upload it from MySQLAdmin)

Does anyone know of an easy way of doing this?

Thanks!

jatar_k

11:21 pm on Jun 17, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



check this out

LOAD DATA INFILE Syntax [dev.mysql.com]