Questions
1 of 13
1How to create tables?
2How to list tables in a database?
3How to modify the structure of a table?
4How to rename a table?
5How to clone tables in mysql?
6How to truncate a table?
7What are Temporary Tables?
8How do we repair tables?
9how to add and delete columns in an existing table?
10How to get information about the table?
11How to lock tables and why do we need to lock a table?
12How to drop a table?
13What are derived tables?
mysqlmysql
Basics
Databases
Tables
Data Types
Queries
Views
Indexes
Clauses
Regex
Functions and Operators
Keys
Joins
Triggers
01 / 13

How to create tables?

A MySQL query to create a table must define the structure of a table. The structure consists of the name of a table and names of columns in the table with each column's data type. Note that each table must be uniquely named in a database.

To begin with, the table creation command requires the following details:
  1. 1

    Name of the table.

  2. 2

    Name of the columns.

  3. 3

    Definitions for each column.

Following is the basic SQL syntax to create a MySQL table: