SELECT
COLUMN_NAME AS '字段名',
DATA_TYPE AS `数据类型`,
CHARACTER_MAXIMUM_LENGTH AS `字符长度`,
NUMERIC_PRECISION AS `数字长度`,
NUMERIC_SCALE AS `小数位数`,
IS_NULLABLE AS `是否允许非空`,
CASE
WHEN EXTRA = 'auto_increment' THEN
1 ELSE 0
END AS `是否自增`,
COLUMN_DEFAULT AS `默认值`,
COLUMN_COMMENT AS `备注`
FROM
information_schema.COLUMNS
WHERE
-- 数据库名称/表空间
TABLE_SCHEMA = 'datas'
-- 要查询数据库表名称
AND TABLE_NAME = 'tables';
查询数据库表结构sql
最新推荐文章于 2024-05-03 11:47:20 发布