SELECT TABLE_NAME AS '表名', COLUMN_NAME AS '字段名', COLUMN_TYPE AS '数据类型', IS_NULLABLE AS '允许为空', EXTRA AS 'PK', COLUMN_COMMENT AS '字段说明' FROM information_schema. COLUMNS WHERE TABLE_SCHEMA = '数据库名称'
2018-09-06 09:10:58 浏览() 来源:http://www.phpdaima.com//jsfx-78.html 评论 ( 0 )
SELECT TABLE_NAME AS '表名', COLUMN_NAME AS '字段名', COLUMN_TYPE AS '数据类型', IS_NULLABLE AS '允许为空', EXTRA AS 'PK', COLUMN_COMMENT AS '字段说明' FROM information_schema. COLUMNS WHERE TABLE_SCHEMA = '数据库名称'