mysql导入导出数据到数据库表

2019独角兽企业重金招聘Python工程师标准>>>

1. 导入导出的目录需要mysql用户权限

2. 导出:

SELECT * FROM hs_store.orders INTO OUTFILE 'sss/articles_3.sql' FIELDS TERMINATED BY ',';

3. 导入:
LOAD DATA INFILE '/var/lib/mysql/sss/articles_3.sql' INTO TABLE demo.articles FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (title,created_at,category_id,tag_id,author_id);

转载于:https://my.oschina.net/bianweiall/blog/517125