How to create a new table into a MySQL database using MySQL Workbench?
Creating a new table into a MySQL database using MySQL Workbench is easy. Without any table, a database is useless. All the data are stored into a database using tables. If you do not know how to create a MySQL database using MySQL workbench, you can read the tutorial Create a new MySQL database with MySQL Workbench? to create a MySQL database. This tutorial will focus only to create a new table into a MySQL database. We will use MySQL workbench to create a new table.
Steps to create a new table into a MySQL database using MySQL Workbench?
Using MySQL workbench, you can create a new table easily. Follow the following steps to create a new MySQL table:
Step 1: Choosing the database to create a new table
Open the database using MySQL where you want to create the new table. For this tutorial, we will use a database named as hubpagesdb which we created in the tutorial Create a new MySQL database with MySQL Workbench?
You can select the database by double clicking the database or by single clicking the small arrow icon.
Step 2: Accessing the "Create Table" option to start creating a new table
When the database will expand, you will see there are several options like Tables, Views, Stored Procedure, Functions. Our target is to create a table. So, we have to work on Tables option. Just right-click on the Tables and a menu appears. From the menu, choose Create Table... option.
Step 3: Getting ready to create a new table
After completing the above step, you will see a new window appears with some form like option. This is the starting of creating a MySQL table. We need to provide table information here. We have to name our table name and table fields etc.
Step 4: Choosing a sample table to create
Suppose we want to create a table for student information and our table name should like Student. And the table will store student identification number, first name and last name. The table may look like the following:
Step 5: Creating the table name
Type the name of the table in the Table Name field. As we already planned in step 4 to create a table named as Student, we type Student in the table name field.
Step 6: Adding table fields information
We have to add the columns of the table. Each column of the table store information. A table has lots of cells and each cell of the column stores data. Data has several types like number type, character type etc. We will not go so details in this tutorials. For easy completion of this tutorial we consider the following things:
- if the value is number type, we define that int type
- if the value is character / string type, we define those using VARCHAR type
For our table, we have three columns: id, first name and last name. First one is the number type and the last two are character / string type. So, we define these as the column name as id, firstName, lastName with the datatype int, varchar2 and varchar2.
Moreover, we create id as primary key. Primary key is used for uniquely identify each row.
Step 6: Saving the table with the columns
When you have completed adding table column information, you have to click on the Apply button to save the table information. Just click on Apply button.
After the above step, MySQL workbench will ask you to confirm with providing the review option. You will see the real sql query to create the table. If everything is OK, click on Apply button.
At last click on Finish button to complete the table creation.
Following the above steps, you will successfully create a table. When the table is successfully created, you will see the table under Tables option like the following figure.
If you expand the table or if you double click the table, the table will expanded and you will see all the table column fields are there.
I believe, following the above steps, you can successfully create a new MySQL table into a MySQL database using MySQL workbench. However, if you face any problem to create a table feel free to comment in the comment section with your problem details.