11 Replies Latest reply: Dec 31, 2012 8:51 AM by APC RSS

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

    982250
      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