- 查询拼接添加索引语句
SELECT
CONCAT('ALTER TABLE `', table_schema, '`.`', table_name, '` ADD INDEX `idx_course_code`(`course_code`);')
FROM
information_schema.TABLES
WHERE
table_name like "course%"
- 将查询的sql拷贝处理执行即可
SELECT
CONCAT('ALTER TABLE `', table_schema, '`.`', table_name, '` ADD INDEX `idx_course_code`(`course_code`);')
FROM
information_schema.TABLES
WHERE
table_name like "course%"