东莞响应式网站实力乐云seo/大连头条热点新闻
SELECTTABLE_NAME AS '表名',COLUMN_NAME AS '字段名',COLUMN_TYPE AS '数据类型',IF(IS_NULLABLE='YES','是','否') AS '是否可为空',COLUMN_COMMENT AS '字段说明'
FROMinformation_schema.`COLUMNS`
WHERETABLE_SCHEMA = '数据库名称'
SELECTTABLE_NAME AS '表名',COLUMN_NAME AS '字段名',COLUMN_TYPE AS '数据类型',IF(IS_NULLABLE='YES','是','否') AS '是否可为空',COLUMN_COMMENT AS '字段说明'
FROMinformation_schema.`COLUMNS`
WHERETABLE_SCHEMA = '数据库名称'