PRIMARY KEY - AUTOINCREMENT
57.2
Exercise

PRIMARY KEY - AUTOINCREMENT

Write a set of SQL statements together to:

  1. create a new table teachers with the following columns, data types and constraints.

    column data type constraint
    id INTEGER PRIMARY KEY, AUTOINCREMENT
    name TEXT NOT NULL
    department TEXT
  2. add these record rows to the created table teachers, in the given order.

    name (TEXT) department (TEXT)
    Marcus Ruby
    Jofra SQL
    Kagiso JavaScript