February 2014
Beginner
1248 pages
62h 25m
English
• 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., '').
Read now
Unlock full access