SELECT table_name AS original_name, 
       SUBSTRING(table_name, 4) AS new_name
FROM information_schema.tables
WHERE table_schema = DATABASE()
AND table_name LIKE 'sw_%';

SELECT VERSION();

-- 步驟1：創(chuàng)建臨時(shí)表存儲(chǔ)重命名映射
CREATE TEMPORARY TABLE temp_rename_mapping (
    old_name VARCHAR(255),
    new_name VARCHAR(255)
);

-- 步驟2：插入需要修改的表名
INSERT INTO temp_rename_mapping
SELECT 
    table_name AS old_name,
    SUBSTRING(table_name, 4) AS new_name
FROM 
    information_schema.tables 
WHERE 
    table_schema = DATABASE()
    AND table_name LIKE 'sw_%';

-- 步驟3：生成并執(zhí)行單個(gè)RENAME語(yǔ)句（更安全的方式）
DELIMITER //
CREATE PROCEDURE batch_rename_tables()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE old_tbl VARCHAR(255);
    DECLARE new_tbl VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT old_name, new_name FROM temp_rename_mapping;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    
    OPEN cur;
    read_loop: LOOP
        FETCH cur INTO old_tbl, new_tbl;
        IF done THEN
            LEAVE read_loop;
        END IF;
        
        SET @rename_sql = CONCAT('RENAME TABLE `', old_tbl, '` TO `', new_tbl, '`');
        PREPARE stmt FROM @rename_sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;
    CLOSE cur;
END //
DELIMITER ;

-- 執(zhí)行存儲(chǔ)過(guò)程
CALL batch_rename_tables();

-- 清理
DROP PROCEDURE batch_rename_tables;
DROP TEMPORARY TABLE temp_rename_mapping;