可以使用以下SQL语句实现:
SET @prefix = 'user';
SELECT
CONCAT('ALTER TABLE ', table_name, ' ADD INDEX idx_index (id);')
FROM
information_schema.tables
WHERE
table_name LIKE concat(@prefix, '%') AND
table_schema = database() AND
NOT EXISTS (
SELECT *
FROM informa