吃饭睡觉打豆豆

SELECT
TABLE_NAME AS '表名',
COLUMN_NAME AS '字段名',
DATA_TYPE AS '数据类型',
IS_NULLABLE AS '是否可空',
COLUMN_DEFAULT AS '默认值',
COLUMN_COMMENT AS '字段注释',
CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',
NUMERIC_PRECISION AS '数值精度',
NUMERIC_SCALE AS '小数位数'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'practice_db'
ORDER BY TABLE_NAME, ORDINAL_POSITION;