Home MySQL Reference CREATE TABLE

CREATE TABLE

command

Creates a new table in the database with defined columns, data types, and constraints.

Syntax

CREATE TABLE table_name (column_definitions, constraints);

Example

sql

CREATE TABLE users (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name       VARCHAR(100) NOT NULL,
    email      VARCHAR(255) NOT NULL UNIQUE,
    password   VARCHAR(255) NOT NULL,
    role       ENUM('admin','user','guest') DEFAULT 'user',
    active     TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

JOIN

ALTER TABLE