sharon Hwk sharon Hwk - 2 months ago 4
MySQL Question

SQL INSERT statement Error - Error at Where clause


Possible Duplicate:

How to add a where clause in a MySQL Insert statement?




I am writing a SQL INSERT STATEMENT with WHERE clause.

INSERT INTO House ( ID ,ADDRESS ) VALUES ('12','LONDON') WHERE OWNER='1';


Error i get :

ERROR 1064 (42000): 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 OWNER='1'' at line 1

sel sel
Answer

WHERE is used in UPDATE query. Use UPDATE for your query if got where clause.

Comments