Using Workbench to add a table

Now, you will use MySQL Workbench to create a table in the autoclub database. You will learn how to add different columns with different datatypes. Additionally, in this section, you will learn the screen layout of the table creation screen.

To create a table, perform the following steps:

1. If you do not already have them opened and connected, open MySQL Workbench and click on My First Connection.
2. Open the autoclub database. Right-click on Tables and then select Create Table:

Figure 2.12: Insert a new table in the autoclub database

A new tab will open, displaying the table design screen, as shown in the following screenshot:

Figure 2.13: The table design screen

This screen is where you will design your tables. It consists of four main areas, which you will look at before you continue with creating a table:

Figure 2.14: The creating a table window section

The following...