Basic Form
Insert statements have the following form:
- INSERT INTO table (column1 ) VALUES (value1 )
The number of columns and values must be the same. If a column is not specified, the default value for the column is used. The values specified (or implied) by the INSERT statement must satisfy all the applicable constraints (such as primary keys, CHECK constraints, and NOT NULL constraints). If a syntax error occurs or if any constraints are violated, the new row is not added to the table and an error returned instead.
Example:
INSERT INTO phone_book (name, NUMBER) VALUES ('John Doe', '555-1212');Shorthand may also be used, taking advantage of the order of the columns when the table was created. It is not required to specify all columns in the table since any other columns will take their default value or remain null:
- INSERT INTO table VALUES (value1, )
Example for inserting data into 2 columns in the phone_book table and ignoring any other columns which may be after the first 2 in the table.
INSERT INTO phone_book VALUES ('John Doe', '555-1212');Read more about this topic: Insert (SQL)
Famous quotes containing the words basic and/or form:
“Our basic ideas about how to parent are encrusted with deeply felt emotions and many myths. One of the myths of parenting is that it is always fun and games, joy and delight. Everyone who has been a parent will testify that it is also anxiety, strife, frustration, and even hostility. Thus most major parenting- education formats deal with parental emotions and attitudes and, to a greater or lesser extent, advocate that the emotional component is more important than the knowledge.”
—Bettye M. Caldwell (20th century)
“Once one is caught up into the material world not one person in ten thousand finds the time to form literary taste, to examine the validity of philosophic concepts for himself, or to form what, for lack of a better phrase, I might call the wise and tragic sense of life.”
—F. Scott Fitzgerald (1896–1940)