CSV -> SQL

[tebrino]

Does anyone know a good way or script which allows you to convert CSV data to SQL code.

Thank you

[Timotheos]

Hi tebrino,

I'm not sure what you mean by "convert CSV data to SQL code". Could you explain what you're trying to do a little bit more?

Thanks,
Tim

[tebrino]

I have large exports in CSV format and I would like to insert them in MySQL database. First line contains field names and other lines contain data. Do yo know some way that I could insert CSV data directly into MySQL database perhaps?

[jatar_k]

try this

[dev.mysql.com...]

[yowza]

I believe this can be done from PhpMyAdmin, as well.