mysql数据导出的sql语句
SELECT * FROM 表名 INTO OUTFILE 'c:/c/data.txt'
or
SELECT * INTO OUTFILE 'c:/c/data.txt' FROM 表名
修改输出的格式
SELECT * INTO OUTFILE 'c:/c/data.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM 表名
mysql数据导入的sql语句
LOAD DATA INFILE 'c:/c/data.txt' INTO TABLE 数据库名.表名