SELECT
column_name,
( CASE WHEN ( is_nullable = 'no' && column_key != 'PRI' ) THEN '1' ELSE NULL END ) AS is_required,
( CASE WHEN column_key = 'PRI' THEN '1' ELSE '0' END ) AS is_pk,
ordinal_position AS sort,
column_comment,
( CASE WHEN extra = 'auto_increment' THEN '1' ELSE '0' END ) AS is_increment,
column_type
FROM
information_schema.COLUMNS
WHERE
table_schema = (
SELECT DATABASE
())
AND table_name = ( '你的表名' )
ORDER BY
ordinal_position;
Mysql 通过表明获取字段以及注释
最新推荐文章于 2023-02-03 14:54:22 发布