Mega Code Archive

 

Categories / MySQL / Command Mysql

 

The syntax of LOAD DATA is as follows

LOAD DATA [loadoptions] INFILE 'filename.txt' [duplicateoptions] INTO TABLE tablename [importoptions] [IGNORE ignorenr LINES] [(columnlist)] LOAD DATA INFILE 'c:/import1-latin1.txt' INTO TABLE importtable1 FIELDS TERMINATED BY '\t' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n' LOAD DATA INFILE '/tmp/import2.txt' REPLACE INTO TABLE importtable2 FIELDS ENCLOSED BY '\"'