The following statement inserts a row into the table 'person':
INSERT person VALUES (3391,'Fred','Marx',-4.75)
Syntactic variants are:
INSERT INTO person VALUES (3395,'Charles','Brand',-4913.00)
INSERT INTO person (cno,name,firstname,account)
VALUES (3396,'Higgins','Mark',-2.19)
INSERT INTO person SET account = -640.30,
name = 'Brown',
firstname = 'Hank',
cno = 3393
If no column names are specified, the sequence of values must correspond to the sequence of the columns in the definition. Both sequences must be identical in length and data type. Undefined values can be written as NULL.
SELECT cno, firstname, name, account
FROM person
The table 'person' can be easily included into the table 'customer' after having been extended by the mandatory columns 'city', 'state', and 'zip':
INSERT INTO customer
SELECT cno, 'Mr', firstname, name, 'New York', 'NY', '10573'
account
FROM person