importing a text file

[cmoore67]

How do I import data from a text file to a mySQL table?

For example

metro.txt contains:

Atlanta, GA
Austin, TX
Seattle, WA

and I want to insert it into a table that will look like:

id:metro:state
1:Atlanta:GA:

where id is auto incremented

Thanks,
Chris

[Anon]

use mysqlimport at the prompt.

more info here:
http://www.mysql.com/doc/m/y/mysqlimport.html

[Anon]

Well, for importing text file you must have tab-delimited text file (filed values in one record are divided by tabs), and fields in this tab must be in the same order like in table. The name of file must be the name of table, for ex. "table1.txt". So, now you should just run import:
mysqlimport -hhost -uuser -ppassword dbname tadle1.txt

where host, user and password are those of your MySQL, dbname - the name of database to which your table belongs.

[mastah]

You can write a simple PHP script to do it. I always like to write my own stuff !🙂

$buffer=file($yourfile);
reset($buffer);
while(list($key,$line)=each($buffer)) {
$fields=split(",",$line);
mysql_query("insert into $table values ('" . join("','",$fields) . "')");
}

I didn't check the syntax , but this is the idea.

-Paulo