导出mysql对应的字段以及注解
SELECT
COLUMN_NAME AS '字段名称',
DATA_TYPE as '字段类型',
CHARACTER_MAXIMUM_LENGTH as '长度',
COLUMN_COMMENT AS '注释'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'ap-invoice'
AND TABLE_NAME = 'b_invoice';
导出mysql对应的字段以及注解
SELECT
COLUMN_NAME AS '字段名称',
DATA_TYPE as '字段类型',
CHARACTER_MAXIMUM_LENGTH as '长度',
COLUMN_COMMENT AS '注释'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'ap-invoice'
AND TABLE_NAME = 'b_invoice';