Home Online Database ERD Activity 1 Activity 2 Activity 3 Activity 4 Activity 5 Activity 6 Activity 7

Activity 4: Inserting new data/records into a table.

Investigate

First start by learning about the SQL INSERT statement by reading through the following web page:

Practice

Use the Online Database to perform the following queries:

DescriptionSQL QueryResults
Add a new shipping company using the following details:
    Name: Global Shipping
    Phone: (503) 555-4523
Add a new employee using the following details:
    Name: James Bond
    DOB: 07/07/1977
    Notes: Special Agent
    No picture provided.
Add a new product using the following details:
    Product: Peanut Butter
    Supplier: 3
    Category: 7
    Unit: 8 oz jars
    Price: £12