SELECT COLUMN_NAME AS ‘字段名’,if( COLUMN_COMMENT is null or COLUMN_COMMENT=’’, COLUMN_NAME, COLUMN_COMMENT) AS ‘备注’ ,COLUMN_TYPE as ‘格式’, IF(column_key=‘PRI’,‘是’,‘否’) AS ‘主键唯一’,
IF(IS_NULLABLE=‘NO’,‘是’,‘否’) AS ‘非空’
FROM information_schema.COLUMNS WHERE TABLE_NAME=‘表名’
(mysql)查询数据库某个表的字段、属性、注释说明、是否主键、是否非空sql
最新推荐文章于 2023-07-28 08:50:44 发布