Column constraints - NOT NULL and UNIQUE
54.2
Exercise

NOT NULL Constraint

Write a set of SQL statements together to:

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

    column data type constraint
    id INTEGER NOT NULL
    name TEXT NOT NULL
    abbreviation TEXT
  2. add these record rows to the created table courses

    id (INTEGER) name (TEXT) abbreviation (TEXT)
    1 JavaScript js