You could use the CSV table type:
http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html
Or use the LOAD DATA INFILE to import all data:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
--rengolin
--- Richard Miller <richardkmiller@stripped> wrote:
> I have a dozen, very large CSV files that I would
> like to put into a
> MySQL database, with 1 table per file. Does anyone
> know of a PHP (or
> other) script that can read the first few lines of a
> CSV file and
> create an appropriate CREATE TABLE statement based
> on the data it
> finds? (Even better, it could import the file
> afterwards!) I'm not
> picky about data types here; I'd simply like to get
> this data into
> tables so I can work with it more easily.
>
> Thanks,
> Richard Miller
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
>
>
Yahoo! Acesso Grátis - Internet rápida e grátis.
Instale o discador agora! http://br.acesso.yahoo.com/
