MySql的导入与导出
时间：2021-07-01 10:21:17
帮助过：3人阅读
/tmp/yhb/skin_info.txt‘ into table t_skin fields terminated by
‘\t‘ (skin_id,img) ;
//指定列导入
load data infile ‘/tmp/yhb/skin_info.txt‘ into table t_skin fields terminated by
‘\t‘;
//不指定列导入
2.导出
select * from yhb into outfile ‘xxx.xls‘; //在MySql客户端直接执行导出语句
//可用脚本导出，比如脚本名称为1.sql
mysql -uuser -ppassword < 1.sql >‘xxx.xls‘
MySql的导入与导出
标签：
