i have a .csv file...can and should i upload to mysql datatbase...

[spewn]

can i upload a .csv file to work with mysql?

- g

 

[towerbase]

Do you mean

[blue]can I populate a MySQL table with data from a CSV file?[/blue]

If yes, then take a look at the LOAD DATA INFILE command on the MySQL website:

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

Andrew
Hampshire, UK

 

[spewn]

Yes, that's what i meant...

i have this:

$dbh=DBI->connect("DBI:mysql:db1_db2:localhost","exm_dbbb","pass");
$sth=$dbh->prepare("LOAD DATA INFILE 'namesfl.txt' INTO TABLE namesfld");
$sth->execute;

seems easy enough...the db is created already, with one field named "namesfld"...but when i run this, it doesn't populate the field in mysql.

in the txt file, the names are listed, one per line.

when i run the script, the names should be entered into db line by line, right?

- g

 

[towerbase]

If you don't specify the delimiters MySQL will assume that your fields are separated with TABs. You will need to modify your LOAD DATA INFILE statement to specify that you are using commas.

Check out the MySQL documentation at

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

There's not much point in me copying it into this reply!

Andrew
Hampshire, UK