navacat中多表批量新增字段

1.需求

在85张表中，新增同样的两个字段，如果一个一个去复制sql，我得做到什么时候，而且容易出错，且枯燥无味。有没有一种方式可以批量去创建sql呢。哎，还真让我搞出来了

2.具体操作

SELECT
	CONCAT( 'ALTER TABLE `', table_name, '`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,',
	'ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;' ) 
FROM
	information_schema.TABLES 
WHERE
	table_schema = '你的数据库名称' 
	AND table_name LIKE 'ods_%';
-- AND table_name LIKE 'ods_%'; 这句sql表示我要修改的表的前缀，查询出要修改的表名

3.实操  

3.1 执行sql

SELECT
	CONCAT( 'ALTER TABLE `', table_name, '`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,',
	'ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;' ) 
FROM
	information_schema.TABLES 
WHERE
	table_schema = 'zhdn_gzmysql' 
	AND table_name LIKE 'ods_%';
	

3.2 执行结果

ALTER TABLE `ods_byqxjysj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_byqxsxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_byqxwjysj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_cjsthdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_cxhzsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_dksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_dyfzsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_dygbxxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_dyrchdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_dyztdrsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_dzzqkjcsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_fwjxzyqksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_fwsztsgzysj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_gjptzydjsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_gzxzssj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_hjjcsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jbsthdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jcjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jhkcsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jshxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jsjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jskhsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jsqyjzsjsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jssplsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jxzlypjsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_jzdsqsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_kcjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_kcjssj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_kthdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_kyjfzcsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_kyxmjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_kyxmyjhdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_lwfbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_lxsxblsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_pksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_qkjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_shsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sjbzyxxxtysgxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_stxhjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxbgjlsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxbxgmqksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxjcsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxjdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxjxgcsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxsjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxwgxwqksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_sxxmsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_szhdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_szjzgsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_szzyjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_tsjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_tsjysj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_tyyhrzdlsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_wlaqglsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_wlkczxxxjlsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xbsjzxsjjcqksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xlzxjlsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xnfzjddwfwsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xnfzszzyjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xnxssshdsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xscystsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xshxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xsjnzssj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xsjzsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xsxfsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xsxksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xxhxtfwjlsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xxhxtjcqksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xxhxtjssj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xxjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xxjxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xxtsxxhxtyysj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_xydtxxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_yktrzsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_yqsbjbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zhcjypjsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zhjssbyxsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zlfbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_ztjhsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zxswblsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zyjnjdjgsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zyjsqksj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zyszsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;
ALTER TABLE `ods_zzfbsj`ADD COLUMN `SJCJFS` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT "数据采集方式" AFTER `PUSHTIME`,ADD COLUMN `SJXZSJ` date NULL DEFAULT NULL COMMENT "数据新增时间" AFTER `SJCJFS`;

将以上sql，复制到navicat中，执行即可。大大的节省时间，剩下的时间，安心摸鱼