Maybe a review of http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html will shed
some light?
-----Original Message-----
From: Renato Golin [mailto:rengolin@stripped]
Sent: Tuesday, April 05, 2005 9:48 PM
To: Richard Miller; Mysql
Subject: Re: CSV-to-SQL?
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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
