MySql的导入与导出

1.导入

load data infile '/tmp/yhb/skin_info.txt' into table t_skin fields terminated by '	' (skin_id,img) ; //指定列导入

load data infile '/tmp/yhb/skin_info.txt' into table t_skin fields terminated by '	'; //不指定列导入

2.导出

select * from yhb into outfile 'xxx.xls'; //在MySql客户端直接执行导出语句
//可用脚本导出，比如脚本名称为1.sql

mysql -uuser -ppassword < 1.sql >'xxx.xls' 

 程序猿必读