mysql数据导入导出语句

导出:SELECT * from ebook INTO OUTFILE "bookdev.txt" FIELDS ENCLOSED by '"' TERMINATED by "," LINES TERMINATED BY "\n"

导入:LOAD DATA INFILE "bookdev.txt" into TABLE ebook  FIELDS ENCLOSED by '"' TERMINATED by ","  LINES TERMINATED BY "\n"

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/huhu/p/137563.html