Update statement with TINYINT variables raises error in mySQL

Question

I try to get a simple update query to work in mySQL, and I can't find an answer.

What I try to do, for "agroforestry" is a tinyint variable :

UPDATE Projects
SET agroforestry = FALSE,
WHERE project_id=2;

This following query works perfectly on the same dataset :

UPDATE Projects
SET contact_person_mail='vincent@lao.be',
    geographical_scope='national',
    country='Belgium',
    budget=4500000,
    currency='EUR'
WHERE project_id=2;

... But I get a syntax error when I try to update tinyint (boolean) variables. I have tried all this :

agroforestry = FALSE
agroforestry = False
agroforestry = false
agroforestry = 'FALSE'
agroforestry = 'False'
agroforestry = 'false'
agroforestry = 0
agroforestry = 1
agroforestry = TRUE
...

Nothing works ! What am I doing wrong ?

Remove the extra comma. Voting to close as a typo. – Sergey Kalinichenko Dec 24 '15 at 20:02 — Sergey Kalinichenko, Dec 24 '15 at 20:02

Redbeard011010 · Accepted Answer · 2015-12-24T20:01:27.773

3

In your example, you have

UPDATE Projects
SET agroforestry = FALSE,
WHERE project_id=2;

Take the comma out, after FALSE. It doesn't belong there. Commas in a SET clause exist only in separating columns. The last column (in this case, the only column) to be modified cannot be followed by a comma.

edited Dec 24 '15 at 20:01

answered Dec 24 '15 at 19:59

Redbeard011010

954
6
20

1

haha, thanks. Hopefully that's the only issue, it sure is the only issue I can see. Guess we'll see, if the asker accepts the answer. :) – Redbeard011010 Dec 24 '15 at 20:05

Update statement with TINYINT variables raises error in mySQL

1 Answers1