Thanks to everyone who helped me with my question below. Here is the
solution I found:
1. I found a website that has a CSV-to-SQL utility. Halfway down the
page you'll see a form where you can upload a CSV file and it will
display corresponding SQL statements, both to create the table
I didn't know the CSV table-type existed -- sounds really cool!
As I understand it, it will save table data in a flat CSV file, but if
I already have a CSV file, can I trick MySQL into thinking it's a
table? That wasn't clear from the documentation.
Richard
On Apr 5, 2005, at 7:47 PM, Renato
On Friday 08 April 2005 06:14, Richard Miller wrote:
I didn't know the CSV table-type existed -- sounds really cool!
As I understand it, it will save table data in a flat CSV file, but if
I already have a CSV file, can I trick MySQL into thinking it's a
table? That wasn't clear from the
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,
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 [EMAIL PROTECTED] wrote:
I have a dozen, very large CSV files that I would
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:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:48 PM
To: Richard Miller; Mysql
Subject: Re: CSV-to-SQL?
You could use the CSV table