In SQL, which of the following syntax is correct for inserting data?

  • A. INSERT INTO tblcustomer WHERE cid = 101 AND name = ‘sok’
  • B. INSERT INTO tblcustomer SET cid = 101 AND name = ‘sok’
  • C. INSERT INTO tblcustomer VALUES(101, ‘sok’)
  • D. None correct

Answer: Option C