extract_user_changed_variables

Parameters

Name	Type
table_name	VARCHAR(50)

SQL Definition

CREATE PROCEDURE `extract_user_changed_variables`(IN table_name VARCHAR(50))
BEGIN
    SET @stmt = CONCAT('SELECT var_name,var_description, var_value, var_unit
                            FROM ', table_name, ' WHERE user_input = 1 ORDER BY var_name;');
        PREPARE stmt FROM @stmt;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
END;;