[SOLVED] Yet another INSERT error

[KevinM1]

Using the same setup from my last thread, I have the following query I'm trying to execute:

INSERT INTO fusion_aw_ec_events (ev_allow_logins) VALUES ('1') WHERE ev_id='11'

 

And, like always, it's giving me an error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ev_id='11'' at line 1

 

Is it breaking on me because I only specify one value to insert?  Or does it not like my WHERE clause?  The column in question is a TINYINT(1) UNSIGNED NOT NULL.

[Wildbug]

And it's the opposite solution as your last thread.  You shouldn't be using quotes for *INT (numeric) values.

 

(Actually MySQL usually correctly interprets numeric strings as numeric values, but maybe SQL strict mode is on or something.  Try removing the quotes and see if you still get the error.)

[KevinM1]

And it's the opposite solution as your last thread.  You shouldn't be using quotes for *INT (numeric) values.

 

(Actually MySQL usually correctly interprets numeric strings as numeric values, but maybe SQL strict mode is on or something.  Try removing the quotes and see if you still get the error.)

 

Not only that, but since I was updating just one column of a row, I should've used UPDATE...SET.  It's fixed now, though.

[Wildbug]

Oh yeah!  *smacks forehead*  That, too.