How to add a where clause in a MySQL Insert statement?
INSERT INTO House ( ID ,ADDRESS ) VALUES ('12','LONDON') WHERE OWNER='1';
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
WHERE is used in
UPDATE query. Use UPDATE for your query if got where clause.