导出语句:
SELECT * INTO OUTFILE "导出的地址+文件名+格式" LINES TERMINATED by "\r\n" FROM test
例子:
SELECT * INTO OUTFILE "C:/Users/zhaody/Desktop/test/demo.xls" LINES TERMINATED by "\r\n" FROM test
导入语句:
LOAD DATA LOCAL INFILE "导出的地址+文件名+格式" INTO TABLE+表名(属性值);
例子:
LOAD DATA LOCAL INFILE "C:/Users/zhaody/Desktop/test/demo.xls" INTO TABLE demo(name, address);