---

The (abbreviated) INSERT command

---

• Inserting tuples into a database
  • The INSERT command can be used to insert one or more tuples into a relation.

  • There are 2 forms of the INSERT command:

    Insert tuple(s) using literal values Insert tuple(s) using result from a SELECT command --- will not discussed

    ---

  • Inserting a tuple using literal (constant) values

    Syntax:

    INSERT INTO relationName VALUES ( .... ) or INSERT INTO relationName(attributeList) VALUES ( .... )

  • Format 1: Inserting ONE COMPLETE tuple:
    You must specify all attribute values in the exact order at the relation schema.

    You can omit the list of attributes.

    Example:

    INSERT INTO employee VALUES ('Richard', 'K', 'Marini', '222669999', '30-Dec-52', '98 Oak Street, Katy, TX', 'M', 37000, '987654321', 4);

  • Format 2: Inserting a PARTIAL tuple:
    You specify a subset of the attribute values in the any order

    You must provide a list of attributes.

    INSERT INTO employee(fname, lname, ssn) VALUES ('Richard', 'Marini', '222669999');

    • NOTE:: The attributes not in the list are given the NULL value