mysql 清理大量数据的存储过程

DELIMITER //

CREATE PROCEDURE BatchDeleteData(IN tableName VARCHAR(255), IN batchSize INT)
BEGIN
    DECLARE totalRows INT;
    DECLARE deletedRows INT;
    DECLARE continueHandler CONDITION FOR SQLSTATE '02000';

    SET @sql = CONCAT('SELECT COUNT(*) INTO @totalRows FROM ', tableName);
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;

    WHILE @totalRows > 0 DO
        SET @sql = CONCAT('DELETE FROM ', tableName, ' LIMIT ', batchSize);
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;

        SET deletedRows = ROW_COUNT();
        SET @totalRows = @totalRows - deletedRows;

        SELECT CONCAT('Deleted ', deletedRows, ' rows. Remaining rows: ', @totalRows);
    END WHILE;
END //

DELIMITER ;