How to Create Table from My sql Database 7 Steps

This article is related to the creation of table using MySql database. In this article we will see the easy steps to create a new table by using MySql database and then assigning the primary key to the table. We will see all the steps with the screenshot so that it will be easy to understand for those who are new to the MySql database.

Step 1
==============
Launch MySql and select new MySql connection. Then asking the password box we have enter the text then Lauch our MySql Server.


Step2
===============
Now open your Mysql management studio . Now type the database name and click apply
Button.

Step3
=======
Get the query for database creation query

Step4
===========
Enter the table name and creation of table

Step 5
============
Create table fields with datatype here ai-> auto increment
in the sql sever we have enter the Identity(1,1) same operation this

Step6
=======
Here we have get the table script

Step7
=========
Select the creation table