How to Create a Table in MySQL Workbench using the GUI

Posted on by Ian

To create a table in the MySQL Workbench GUI:

  1. Under the appropriate database in the left navigation pane, right-click Tables and select Create Table...
  2. Enter the table name, add all column names, their data type, constraints, default values, and any other details as required, then click Apply
  3. Review the SQL statement that will be run against the database and click Apply

The table will now be created, and a message will display advising that the script was successful.

Below are screenshots of the above steps.

The Left Navigation Pane

Under the appropriate database in the left navigation pane, right-click Tables and select Create Table...:

Screenshot of selecting Create Table from the left navigation pane
Create a new table by right-clicking on the “Tables” node under the database that you want to create the table in.

Configure the Table

Enter the table name, add all column names, their data type, constraints, default values, and any other details as required, then click Apply:

Screenshot of the new table being configuring.
Configuring the new table by naming it, adding column, data types, and more.

Create the Table

Review the SQL statement that will be run against the database and click Apply:

Screenshot of reviewing the SQL script before applying it to the database.
MySQL gives you a chance to review the script before applying it to the database.

The table will now be created, and a message will display advising that the script was successful.

You can now navigate to the table in the left navigation pane. Expanding the table will reveal the columns that you specified.

Screenshot of expanding the table.
Expanding the table will reveal its columns.