update logger_variables set name = :name, unit = :unit, type = :type where variable_id = :variable_id select variable_id, name, unit, type from logger_variables where variable_id = :variable_id