lundi 10 août 2015

SQLite 3 substract in update query gives near "–": syntax error

I am trying to execute update query with subtraction inside:

UPDATE categories_ns
SET
 nsright = nsright – 10
WHERE
    nsright > 9

And I am getting [Err] 1 - near "–": syntax error.

Could you please help me to understand why its happens ?

Thanks!

Aucun commentaire:

Enregistrer un commentaire