1、導出sql
-- 數(shù)據(jù)庫表結構
SELECT
col.TABLE_NAME 表名,
tab.TABLE_COMMENT 表中文名,
col.COLUMN_NAME 列名,
col.COLUMN_COMMENT 備注,
col.COLUMN_TYPE 數(shù)據(jù)類型,
col.DATA_TYPE 字段類型,
col.CHARACTER_MAXIMUM_LENGTH 長度,
col.IS_NULLABLE 是否為空,
col.COLUMN_DEFAULT 默認值
FROM
INFORMATION_SCHEMA.COLUMNS col
LEFT JOIN information_schema.TABLES tab on col.TABLE_NAME = tab.TABLE_NAME
WHERE
-- 對應的數(shù)據(jù)庫
col.table_schema = 'db_hold_plan'
and col.table_name in ('product','product_grade','client_payment','interest_liquidation','interest_liquidation_his','sales_detail','commission_hold','redemption_rule','redemption','redemption_audit','redemption_lineitem')
and tab.TABLE_SCHEMA = 'db_hold_plan'
-- 排序
ORDER BY field(col.TABLE_NAME,'product','product_grade','client_payment','interest_liquidation','interest_liquidation_his','sales_detail','commission_hold','redemption_rule','redemption','redemption_audit','redemption_lineitem')
