MySQL txt converting

[Guest_imported]

Does anyone know how to convert from the a text file that contains commands to make a new database (ie "customer.txt&quot into an SQL file. It's rumored there is a command, but I can't find it.

 

[sophisticate]

Just use the &quot;mysql&quot; binary using the &quot;<&quot; operator.

eg.
/usr/bin/mysql -u someone -p database_name < customer.txt

That'll do it.

brendanc@icehouse.net

 

[Guest_imported]

This is what I did:
First I created the database with:

CREATE TABLE ptree2000 (rank INT, firstname VARCHAR(25), lastname VARCHAR(20), age INT, location VARCHAR(30), racetime TIME);

Then I loaded the data into it with:

LOAD DATA LOCAL INFILE 'ptree2000.csv' INTO TABLE ptree2000 FIELDS TERMINATED BY ',';

FYI: My source data was an Excel file that I had saved into CSV format.