【无标题】

导出ddl
SELECT COLUMN_NAME as 字段名称,
DATA_TYPE as 字段类型,
CHARACTER_MAXIMUM_LENGTH as 长度,
if(COLUMN_KEY = ‘PRI’, ‘Y’, ‘N’) as 主键,
IS_NULLABLE as 是否为空,
COLUMN_DEFAULT as 默认值,
COLUMN_COMMENT as 默认值
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = ‘’
AND table_name = ‘’
;