Column constraints - NOT NULL and UNIQUE
54.4
Exercise

UNIQUE Constraint

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 UNIQUE
    name TEXT UNIQUE
    age INTEGER
  2. add these record rows to the created table teachers

    id (INTEGER) name (TEXT) age (INTEGER)
    1 Phil 29