update_variable_info_on_name

Parameters

Name	Type
table_name	VARCHAR(50)

SQL Definition

CREATE PROCEDURE `update_variable_info_on_name`(IN table_name VARCHAR(50))
BEGIN
    SET SQL_SAFE_UPDATES = 0;
        SET @stmt = CONCAT('UPDATE ', table_name, ' SET var_value = ?,
                            var_unit = ?,
                            user_input = ? WHERE var_name = ?');
    PREPARE stmt FROM @stmt;
    SET @var_value = value;
    SET @var_unit = unit;
    SET @user_input = 1;
    SET @var_name = u_i_var_name;
    EXECUTE stmt USING @var_value, @var_unit, @user_input, @var_name;
    DEALLOCATE PREPARE stmt;
END;;