How to create a new table in MySQL database?

How to create a new table in MySQL database?

Database, MySQL, Table

78 | 0 | 0

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)
);

 

Comments (0)

🤔

No comments yet, be the first to help

Welcome to CodePits.

CodePits provide a collection of tutorials about many programming languages like PHP, Laravel Framework, Codeigniter Framework, Mysql Database, Bootstrap Front-end Framework, Jquery, Node JS, Ajax Example, APIs, CURL Example, Composer Packages Example, AngularJS, Ionic Framework, etc. 🙌

Other Posts

Categories

Tags

Comment