get data into mysql

[hoojar]

hi,

whats the quickest way to get data into a mysql database?

i'l be handling files with upto 1,000,000 records and up until now i've been using ms access (which i really want to get away from).

i've tried using php to read the data file, record at a time and then add it to a table but that was really slow.

is there a direct way to do it straigt from mysql, like in access i would just "import".

thanks.

 

[hvass]

You should take a look at

load data infile ''
into mytable

syntax

 

[hoojar]

thanks,

i did it like this:

LOAD DATA INFILE 'c:/data/test.txt' INTO TABLE big
FIELDS TERMINATED BY '*';