SQL Syntax - TechRepublic
General discussion
June 27, 2001 at 06:51 AM
afisher

SQL Syntax

by afisher . Updated 25 years ago

What is wrong with the syntax in the following line?

UPDATE tblContacts SET cName = ‘Bob’, SET cAddress = ‘494 Dale’, SET cPhone = ‘494-0494’ WHERE cID = ‘0’

I tried to run it using AND instead of commas and without the ticks before and after each of the new field values, but to no avail.

This discussion is locked

All Comments