mysql数据导入导出语句
导出:
SELECT * from ebook INTO OUTFILE "bookdev.txt" 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"
posted on 2005-06-23 08:23 Eric Zhang 阅读(462) 评论(0) 收藏 举报
浙公网安备 33010602011771号