Create A Table

Define a new table with column names and data types using `CREATE TABLE`.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Create a users table and insert the first row

The table is created with three columns, a row is inserted, and a SELECT confirms the structure works. In production, add PRIMARY KEY and NOT NULL constraints to enforce data integrity.

Validated query Shared across supported engines.

SQL

CREATE TABLE users (id INT, name VARCHAR(50), email VARCHAR(100));

INSERT INTO
  users (id, name, email)
VALUES
  (1, 'Alice', '[email protected]');

SELECT
  id,
  name,
  email
FROM
  users;

Expected result Returned rows for the shared example.

id	name	email
1	Alice	[email protected]

Output is identical across all engines.

Useful when

Where this command helps.

setting up a new table before inserting data
defining the column structure and data types for a new entity

Explanation

What the command is doing.

CREATE TABLE establishes a new table in the current database. Each column definition requires a name and a data type. Common types include INT for integers, VARCHAR(n) for variable-length strings, and DATE for calendar dates. The table is empty until rows are inserted.

Create A Table

Create a users table and insert the first row

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.