因为要给项目做数据字典,需要把两个数据库的表注释和列注释同步,现记录如下
导出表注释:
SELECT GROUP_CONCAT('alter table ',table_name,' comment ',"'",TABLE_COMMENT,"'",';') FROM information_schema.TABLES WHERE TABLE_SCHEMA='dcs_dev' GROUP BY table_name;
导出列注释:
SELECT GROUP_CONCAT('alter table ',table_name, ' MODIFY COLUMN ',column_name,' ',column_type,' comment ',"'",column_COMMENT,"'",';') FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='dcs_dev'
AND table_name LIKE 'tbl_base%' GROUP BY table_name,column_name;
把查询的内容复制出来,然后在目标库执行就好了