remove_specific_row

Parameters

Name	Type
table_name	VARCHAR(50)
target_code	VARCHAR(50)

SQL Definition

CREATE PROCEDURE `remove_specific_row`(IN table_name VARCHAR(50), IN target_code VARCHAR(50))
BEGIN
    SET SQL_SAFE_UPDATES = 0;

        SET @stmt = CONCAT(
            'DELETE FROM ', table_name,
            ' WHERE code_of_account = \'', target_code, '\''
        );

        -- Debug: Print the constructed SQL statement
        SELECT @stmt;

        PREPARE stmt FROM @stmt;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
END;;