How do I create a table in MySQL

To create a table in MySQL, you can use the CREATE TABLE statement. This statement allows you to define the structure of the table, including the columns, their data types, and any constraints such as primary keys.

Example of Creating a Table in MySQL


CREATE TABLE employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE,
    hire_date DATE
);