insert into logger_variables (variable_id, name, unit, type) values (:variable_id, :name, :unit, :type) delete from logger_variables where variable_id = :variable_id select variable_id, name, unit, type from logger_variables where variable_id = :variable_id