2nd Sep, 2007

Load Data into Table

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;

Author: LJ Arthur Neil

Categories:
MySQL

Leave a response






Your response:

Categories and Tags

Advertising