查询所有表名(已测试)
select table_name from information_schema.tables where table_schema='rigourdata'
导出到文件(未测试)
select * from information_schema.tables into outfile 'd:/文件名.xls';
查询所有表名(已测试)
select table_name from information_schema.tables where table_schema='rigourdata'
导出到文件(未测试)
select * from information_schema.tables into outfile 'd:/文件名.xls';
转载于:https://my.oschina.net/iyinghui/blog/1627805