Mysql分表创建索引

查询拼接添加索引语句

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拷贝处理执行即可

原文链接：https://blog.csdn.net/weixin_42202489/article/details/125678970