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.