mysql 导出查询结果

show variables like '%secure%'; 看看导出位置

SELECT * FROM tb WHERE sn = '1' 
LIMIT 1,10
into outfile '/var/lib/mysql-files/SPH.txt'

posted @ 2019-08-03 08:28  ahuo  阅读(4188)  评论(0编辑  收藏  举报