This discussion is archived
11 Replies Latest reply: Dec 31, 2012 6:51 AM by APC RSS

why we need where clause in insert stt. when i have already update stt.

982250 Newbie
Currently Being Moderated
I am getting stuck at this point, why we need where clause in insert statement when i have already update statement. If i have update statement with where clause then why insert statement with where clause or vice-versa.

Ex :-

INSERT INTO supportContacts (details) VALUES ('admin') WHERE id = 2;

or

UPDATE supportContacts  SET details = 'admin' where id = 2;

Edited by: 979247 on Dec 30, 2012 10:54 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points