update_account_before_insert

Parameters

Name	Type
table_name	VARCHAR(50)
min_ind	INT

SQL Definition

CREATE PROCEDURE `update_account_before_insert`(IN table_name VARCHAR(50), IN min_ind INT)
BEGIN
    SET SQL_SAFE_UPDATES = 0;
        SET @stmt = CONCAT('UPDATE ', table_name,
                           ' SET ind = ind + 1 WHERE ind >?');
        PREPARE stmt FROM @stmt;
        SET @min_ind = min_ind;
        EXECUTE stmt USING @min_ind;
        DEALLOCATE PREPARE stmt;
END;;