information_schema :数据库信息表
SHOW DATABASES:查询mysql中所有数据库列表
SHOW TABLES FROM ebiz_edor:查询数据库中表信息
SHOW COLUMNS FROM ebiz_edor.ebiz_data_dis:查询某个库中某张表的列信息
SHOW INDEX FROM ebiz_edor.ebiz_surrender;:查询数据中表的索引信息
查询某个数据库有多少张表
SELECT COUNT(*) as '数量', table_schema FROM information_schema. TABLES WHERE table_schema = 'ebiz_insurance';