Section 24.4.6 UPDATE Statement

• 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.

Get Java™ How To Program (Early Objects), Tenth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.