Create a table with an auto-increment primary key and timestamps.

Section: create and alter tables

Create a users table

sql
sql
CREATE TABLE users (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  email VARCHAR(255) NOT NULL,
  full_name VARCHAR(255) NOT NULL,
  is_active TINYINT(1) NOT NULL DEFAULT 1,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  UNIQUE KEY uq_users_email (email)
) ENGINE=InnoDB;
Explanation

A common baseline table definition for application data.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing create and alter tables
Create a database
Create a schema if it does not already exist.
OpenIn sheetsqlsame section
Add a column
Add a nullable column to an existing table.
OpenIn sheetsqlsame section
Modify a column definition
Change type, size, or nullability.
OpenIn sheetsqlsame section
Rename a column
Rename a column while specifying its full definition.
OpenIn sheetsqlsame section
Drop a column
Remove a column from a table.
OpenIn sheetsqlsame section
Rename a table
Rename a table without recreating it.
OpenIn sheetsqlsame section