批量添加索引,批量修改字段长度

–批量添加索引
SELECT i.TABLE_SCHEMA,i.TABLE_NAME, CONCAT(‘ALTER TABLE ‘,i.TABLE_NAME,’ ADD INDEX idx_t_building (id);’)
FROM INFORMATION_SCHEMA.STATISTICS i
WHERE TABLE_SCHEMA = ‘uadb’ and table_name like ‘t_buildingaddress%’ and table_name not like ‘%_history’ GROUP BY i.TABLE_NAME;

–批量修改字段长度
SELECT i.TABLE_SCHEMA,i.TABLE_NAME, CONCAT(‘ALTER TABLE ‘,i.TABLE_NAME,’ MODIFY COLUMN AREACODE varchar(90);’)
FROM INFORMATION_SCHEMA.STATISTICS i
WHERE TABLE_SCHEMA = ‘uadb’ and table_name like ‘t_homeaddress%’ and table_name not like ‘%_history’ GROUP BY i.TABLE_NAME;