Load Data into Table | NeilSys

Feeds:: Posts; Comments

Load Data into Table

Sep 2nd, 2007 by L J Arthur Neil

Import

LOAD DATA INFILE ‘data.txt’ INTO TABLE table_name FIELDS
TERMINATED BY ‘t’ LINES TERMINATED BY ‘n’;

Export

SELECT * INTO OUTFILE ‘data.txt’ FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘n’ FROM
table_name;

Posted in MySQL | Leave a Comment

Leave a Reply Cancel reply