MySql的导入与导出

/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的导入与导出

标签：