ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How to create a new table into a MySQL database using MySQL Workbench?

Updated on December 23, 2013

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:

Student

id
firstName
lastName
 
 
 
 
 
 
 
 
 

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.

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      Nina 

      4 years ago

      Very useful

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)