SELECT
CONCAT('ALTER TABLE ',table_name,' ADD COLUMN `create_server` tinyint(4) NOT NULL DEFAULT 1 COMMENT \'创建服务(1集团服务 2网货数据服务)\' AFTER `create_org_id`;')
FROM
information_schema.COLUMNS
WHERE
table_schema = 'yunxiao_dev_jituan_11.3_trilateral'
AND LEFT ( table_name, 3 ) = 'hdd'
AND COLUMN_NAME = 'create_org_id';
05-13
428
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
09-14
2209
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
09-23
1万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-14
2763
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)