Clojure: How do I delete an entry from a table when the rows are null? (in other words, containing no value)

Question

(sql/delete-rows "tableName" ["scenarioname = ? AND scenarioid= ?" nil nil]))

For some reason, this doesn't work... Why?

Answer 1

what you want is

(sql/delete-rows :tablename ["scenarioName is null and scenarioid is null"])

or

(sql/delete! dbcon :tableName ["scenarioName is null and scenarioid is null"])

assuming dbcon as your db connection.

Notes

• delete-rows is deprecated ->
  http://clojure.github.io/java.jdbc/#clojure.java.jdbc.deprecated/delete-rows use delete!
• null != null in SQL ->
  Why does NULL = NULL evaluate to false in SQL server
• clojure.java.jdbc where clause does not support operators like "is"
  "in" and "between"