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"
导出: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"
