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

 



posted @ 2016-04-27 16:30  IAMME  阅读(164)  评论(0)  编辑  收藏  举报