做一个简单的记录:
mysql查询数据库表和对应的注解:
SELECT TABLE_NAME AS '表名',table_rows,table_comment AS '注释' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '你的数据库'
查询数据库中的表是否为空
select table_name from information_schema.tables where table_schema = '你的数据库' and table_rows >1;