Project design

Set up the table structure of the CRUD app and write skeleton queries.

In this project you will build the table structure of a simple CRUD app. First step is to create the notes table.

CREATE TABLE notes (
  id INT PRIMARY KEY,
  title VARCHAR(100),
  body TEXT
);

This table has id, title and body columns. id is the primary key.

The table notes is created.

Project design — details

CRUD stands for Create-Read-Update-Delete. You create a table, then insert, read, update and delete data. This lesson sets up the table.

Create the notes table with id (INT PRIMARY KEY), title (VARCHAR(100)) and body (TEXT).

Show example solution

CREATE TABLE notes (
  id INT PRIMARY KEY,
  title VARCHAR(100),
  body TEXT
)

Create table

CREATE ____ notes (id INT PRIMARY KEY, title VARCHAR(100));

Show answer

CREATE TABLE notes (id INT PRIMARY KEY, title VARCHAR(100));

Next lesson: Reading data