使用语句显示表结构

最新推荐文章于 2024-10-01 17:33:05 发布

杨晨龙

最新推荐文章于 2024-10-01 17:33:05 发布

阅读量535

点赞数 6

文章标签： mysql

本文链接：https://blog.csdn.net/weixin_47963446/article/details/139932122

版权

set @db_name='库名'; set @table_name='表名'; SELECT
COLUMN_NAME 字段名,
COLUMN_TYPE 数据类型, IF
(
COLUMN_NAME IN ( SELECT COLUMN_NAME FROM
information_schema.KEY_COLUMN_USAGE AS T WHERE T.table_schema =
@db_name AND T.table_name = @table_name ),
'PRIMARY KEY',
IF
( IS_NULLABLE = 'NO', 'NOT NULL', 'NULL' ) ) AS `主键/允许空`,
COLUMN_COMMENT 字段含义
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = @db_name
AND table_name = @table_name;