CREATE TABLE defines a new table structure in your database. Learn to design tables with proper data types and constraints.

Basic CREATE TABLE Syntax

CREATE TABLE table_name (

column1 datatype,

column2 datatype

);

Create Table with Primary Key

CREATE TABLE customers (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(100) NOT NULL,

email VARCHAR(255) UNIQUE,

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

Create Table with Foreign Key

CREATE TABLE orders (

id INT PRIMARY KEY AUTO_INCREMENT,

customer_id INT,

total DECIMAL(10,2),

FOREIGN KEY (customer_id) REFERENCES customers(id)

);

Common Data Types

INT: Whole numbers

VARCHAR(n): Variable-length strings

TEXT: Long text

DECIMAL(p,s): Precise numbers

DATE/DATETIME: Dates and times

BOOLEAN: True/False values

Generate CREATE TABLE

Describe your table structure and AI2sql generates the CREATE statement.