CREATE TABLE basics

Create a new table.

With CREATE TABLE you create a new table. Column names and types go in parentheses, separated by commas.

CREATE TABLE products (
  id INT,
  name VARCHAR(100)
);

This query creates the products table with id and name columns.

The table products is created.

CREATE TABLE basics — details

Each column takes a name and a type. Columns are separated by commas; no comma after the last one. The table name must be unique.

Create products with id INT and name VARCHAR(100).

Show example solution

CREATE TABLE products (
  id INT,
  name VARCHAR(100)
)

Create table

CREATE ____ products (id INT, name VARCHAR(100));

Show answer

CREATE TABLE products (id INT, name VARCHAR(100));