SELECT
COLUMN_NAME,
COLUMN_TYPE,
COLUMN_KEY,
COLUMN_COMMENT,
( CASE WHEN IS_NULLABLE = 'NO' THEN '否' ELSE '是' END )
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA='数据库名'
AND
table_name='表名'
MySQL数据库表设计导出语句
最新推荐文章于 2024-06-27 17:47:51 发布