Auto-create table based on CSV file?

[Richard Edwards]

Is it possible to load a csv file and MySQL autocreate a table based on the
contents?

Thanks

Richard

[Michael Austin]

obviously you have not searched the docs.. this may or may not be what
you are looking for:

http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html

but initial review indicates you will still need to create the table
first using Engine:csv..

[Richard Edwards]

thanks very much.

i had looked through the docs but not being a developer or database guru i
had no idea what to look for...

"Michael Austin" <mau...@firstdbasource.com> wrote in message
news:lQyrl.19198$c45....@nlpi065.nbdc.sbc.com...

[toby]

Use CREATE TABLE to define column names and types. Then you can very
easily use LOAD DATA INFILE to import the data from CSV.

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

Or see Michael's suggestion.

[aminr...@gmail.com]

Did you find the answer?

[Jerry Stuckle]

After over 4 years, I very much doubt he's going to answer.

But then it's only the Google Groupies who would expect an answer after
that long.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

[Luuk]

Google has a link to an interesting post about that....

it can be found here:
http://stackoverflow.com/questions/9998596/create-mysql-table-directly-from-csv-file-using-the-csv-storage-engine