Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

get data into mysql

Status
Not open for further replies.

hoojar

Programmer
May 26, 2005
14
GB
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.
 
You should take a look at

load data infile ''
into mytable

syntax

 
thanks,

i did it like this:

LOAD DATA INFILE 'c:/data/test.txt' INTO TABLE big
FIELDS TERMINATED BY '*';
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top