csv to sql

[henry2010]

Is there any way to convert csv files to sql files in fedora. or any package available to convert csv file to sql file.

henry

[smr54]

A quick search, using linux csv to sql brings up this.
http://www.thejackol.com/2005/02/28/...sv-into-mysql/

Just putting csv to sql into google brings up several online tools if it's non-sensitive information.

[wireman]

Henry, what you're asking is not exactly clear.

CSV files are for storing data whereas SQL is a language for querying data, so converting one to the other doesn't really make sense. Do you mean you want to put your CSV formatted data into a database (as per smr54's link) and then query it (with SQL) or something else?

[errorxp]

I believe you can use phpmyadmin to import from csv files to mysql database. Although when you've got lots of csv files this approach can be a bit tedious - I ended up creating a python script for importing data to mysql. After that you could export your data to a .sql file (either using phpmyadmin or sqldump for example) if tha'ts what you want.

[george_toolan]

Which DBMS are you using?

[henry2010]

My database is Mysql , phpmyadmin is my front end tool. I want to import my data from csv file. I could'nt import data. from sql file data can be imported very easily. hence I want one converter from csv to sql format.

henry

[wireman]

Then, the way to get csv data into MySQL is via the commandline as shown in the link given by smr54. Or google 'load data infile mysql'