Section 24.4.5 INSERT Statement
• An INSERT statement (p. 1058) inserts a new row into a table. The basic form of this statement is
INSERT INTO tableName (columnName1, columnName2, ..., columnNameN) VALUES (value1, value2, ..., valueN)
where tableName is the table in which to insert the row. The tableName is followed by a commaseparated list of column names in parentheses. The list of column names is followed by the SQL keyword VALUES (p. 1058) and a comma-separated list of values in parentheses.
• SQL uses single quotes (') to delimit strings. To specify a string containing a single quote in SQL, escape the single quote with another single quote (i.e., '').
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.
