mysql 查询表相关信息

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '数据库名'


select table_schema,table_name,column_name  from information_schema.columns order by table_schema,table_name