Data update

Write a calculated UPDATE based on existing data.

Challenge 3: Create a table

In this challenge you will create a table with PRIMARY KEY, NOT NULL and DEFAULT.

CREATE TABLE books (id INT PRIMARY KEY, title VARCHAR(100) NOT NULL, copies INT DEFAULT 1);

This query books table; title required, copies default to 1.

The table books is created.

Create books with id INT PRIMARY KEY, title VARCHAR(100) NOT NULL, copies INT DEFAULT 1.

Show example solution

CREATE TABLE books (
  id INT PRIMARY KEY,
  title VARCHAR(100) NOT NULL,
  copies INT DEFAULT 1
)

Table constraint

CREATE TABLE books (
  id INT PRIMARY ____,
  title VARCHAR(100) NOT NULL
);

Show answer

CREATE TABLE books (
  id INT PRIMARY KEY,
  title VARCHAR(100) NOT NULL
);