SET SESSION group_concat_max_len = 102400;
SELECT CONCAT('DROP VIEW IF EXISTS V_', c.TABLE_NAME, '; \n'
, 'CREATE VIEW V_', c.TABLE_NAME, ' AS ( \nSELECT\n', GROUP_CONCAT(' ', COLUMN_NAME, ' -- ', column_comment separator '\n,'), ' \nFROM ', c.TABLE_NAME, ' tb -- ', t.TABLE_COMMENT ,'\nORDER BY ID DESC \nLIMIT 1000 \n);') AS SQL1
FROM information_schema.COLUMNS c
INNER JOIN information_schema.`TABLES` t ON t.TABLE_NAME = c.TABLE_NAME AND t.TABLE_SCHEMA = 'db_eam_cd'
WHERE c.table_schema = 'test'
GROUP BY c.TABLE_NAME
;
导出数据库所有表视图脚本
最新推荐文章于 2023-07-09 22:00:43 发布