
Posted on: 7 months ago
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)
);
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
Comments (0)
🤔
No comments yet, be the first to help
load more