`

mysql 数据导出导入

阅读更多

select * from t_user into outfile "D:/user"  fields terminated by ',' optionally enclosed by '"' lines terminated by '\n';




load data infile 'D:/user' replace into table tmp_user fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' ;

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics