How to create a new table in MySQL database?

We can use CREATE TABLE statement to create a new table in database.

Syntax:

CREATE TABLE <table_name> (
    <column_name_1> datatype,
    <column_name_2> datatype,
    <column_name_3> datatype,
    ....
);

Example:

CREATE TABLE employees (
    id int,
    first_name varchar(255),
    last_name varchar(255),
    email varchar(255),
    City varchar(255),
    state varchar(255),
    country varchar(255)
);