導出數據到txt:spa
1.select 列1,列2, ....... 列n from tbname [where 條件] into outfile "C:\backup\data.txt" FIELDS TERMINATED BY '\t' lines terminated by '\n';orm
導出的數據是每列用tab 分開的具體數據，就好像一個矩陣同樣。it
從txt導入數據：table
2.load data local infile "C:\backup\data.txt" into table tbname FIELDS TERMINATED BY '\t' lines terminated by '\n' (id,....表字段名);file
data.txt裏面的數據字段應該和（）裏面的字段相對應select
ps: csv與txt相似csv