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

  • A. UPDATE tblcustomer WHERE cid = 101
  • B. UPDATE tblcustomer ON name = ‘sok’ WHERE cid = 101
  • C. UPDATE tblcustomer
  • D. None correct

Answer: Option C