How to create tables?

Q: How to create tables?

Name of the table. Name of the columns. Definitions for each column. CREATE TABLE table_name( column1 datatype, column2 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );

Difficulty: 4/10

CREATE TABLE syntax, constraints & indexes, schema migrations

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
Name of the table.
2
Name of the columns.
3
Definitions for each column.

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

Scenario Questions

0-2 years experience

Follow-up Questions