cmcculloh.com - Personal - Tutorials - SQL Lectures - 2.14.06: Relational Databases - Insert Data into People Table

Insert into People

Michael Xue
Christopher McCulloh
2.14.06

Now let's insert the following into the table:

'William', 'Turner', 'M', '1972-05-27'
'Susan', 'Smith', 'F', '1975-11-02', '23 Maple street', 'Arlington', 'VA', 'USA', '20220'

To do this, we will use the following code:

insert into person (fname, lname, gender, birth_date) values ('William', 'Turner', 'M', '1972-05-27') ; insert into person (fname, lname, gender, birth_date, address, city, state, country, postal_code) values ('Susan', 'Smith', 'F', '1975-11-02', '23 Maple street', 'Arlington', 'VA', 'USA', '20220') ;

Note that we do not include the person_id in our insert statement.