Let's continue toward the goal of making a
table exactly like the friend table shown in Table ![[*]](cross_ref_motif.gif)
.
So far, we have created the table, but it does not contain any friends.
You add rows into a table with the INSERT statement.
Just as CREATE TABLE has a specific format that must be followed,
INSERT also has a specific format. Figure
shows this format.
test=> INSERT INTO friend VALUES (
test(> 'Mike',
test(> 'Nichols',
test(> 'Tampa',
test(> 'FL',
test(> 19
test(> );
INSERT 19053 1
You must use single quotes around the character strings. Double quotes
will not work. Spacing and capitalization are optional, except inside
the single quotes. Inside them, the text is taken literally, so any
capitalization will be stored in the database exactly as you specify.
If you type too many quotes, you might reach
a point where your backslash commands do not work anymore, and your
prompt will appear as test'>. Notice the single quote
before the greater than symbol. Just type another single quote to
get out of this mode, use \r to clear the
query buffer, and start again. Notice that the
19 does not have quotes. It does not need them because the
column is a numeric column, not a character column. When you do your
INSERT operations, be sure to match each piece of data to
the receiving column. Figure shows
the additional INSERT commands needed to make the friend
table match the three friends shown in Table .
test=> INSERT INTO friend VALUES (
test(> 'Cindy',
test(> 'Anderson',
test(> 'Denver',
test(> 'CO',
test(> 23
test(> );
INSERT 19054 1
test=> INSERT INTO friend VALUES (
test(> 'Sam',
test(> 'Jackson',
test(> 'Allentown',
test(> 'PA',
test(> 22
test(> );
INSERT 19055 1