Learn SQL/

...

/

Solution: Design Better Tables

Solution: Design Better Tables

We'll cover the following...

Query

CREATE TABLE books (
    id INTEGER PRIMARY KEY,
    title TEXT NOT NULL,
    pages INTEGER CHECK(pages > 0)
);

Explanation

This command creates a new table named books to store ...