mysql的匯出與匯入5/5

匯出:
SELECT * INTO OUTFILE 'data.txt'
  FIELDS TERMINATED BY ','
    FROM table;
匯入:
LOAD DATA INFILE 'data.txt' INTO TABLE table2
   FIELDS TERMINATED BY '\t';

只匯入部分欄位 
If you want to load only some of a table's columns, specify a column list:
LOAD DATA INFILE 'persondata.txt'
INTO TABLE table (col1,col2,...);

P.S.之前有用load data infile匯入過幾次,匯入的第一筆資料中主KEY會有亂碼