February 2014
Beginner
1248 pages
62h 25m
English
• An UPDATE statement (p. 1059) modifies data in a table. The basic form of an UPDATE statement is
UPDATE tableName SET columnName1 = value1, columnName2 = value2, ..., columnNameN = valueN WHERE criteria
where tableName is the table to update. Keyword SET (p. 1059) is followed by a comma-separated list of columnName = value pairs. The optional WHERE clause determines which rows to update.
Read now
Unlock full access