select * into outfile ‘文件导出路径’ from 表明 where 条件(LENGTH(CARD_CODE)<=9);
导出查询结果:
select * into outfile ‘D:/catid1.xls’ from card_info where LENGTH(CARD_CODE)<=9;
mysql将查询结果集导出excel
最新推荐文章于 2024-07-30 11:59:57 发布
select * into outfile ‘文件导出路径’ from 表明 where 条件(LENGTH(CARD_CODE)<=9);
导出查询结果:
select * into outfile ‘D:/catid1.xls’ from card_info where LENGTH(CARD_CODE)<=9;