SQL脚本输出数据表定义

根据SQL脚本输入数据库定义.

这个SQL脚本一定要在information_schema库里执行。

SELECT column_name AS '字段', 
IF(CHARACTER_MAXIMUM_LENGTH IS NULL, data_type, CONCAT(data_type, '(', CHARACTER_MAXIMUM_LENGTH, ')')) AS '类型',
case IS_NULLABLE when 'NO' then 'N' ELSE 'Y' END 是否可为空,
IFNULL(COLUMN_DEFAULT, '') AS '默认值',
COLUMN_COMMENT AS '描述'
FROM `columns` 
WHERE 1=1 AND table_schema='data_integration' AND table_name IN ('finance_pre_warehousing_fee')
ORDER BY table_name,ORDINAL_POSITION ;