insert query giving error

[Jaswinder]

Insert  query not working

insert into user(code) values('saafvjfjeklwvlk') where email='[email protected]'

tablename - user

column name - code

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 email='[email protected]''

 

Any idea ?

[mac_gyver]

INSERT queries don't have WHERE clauses. an INSERT query inserts a new row, using the values you supply in the query. perhaps you are thinking of an UPDATE query?

[Jaswinder]

Now i really pissed off, such a big mistake.. i really need break from coding

 

thanks for correcting me