DbSchema Database Designer

DbSchema | MySQL - How to Create a Table?

Publish on DbSchema Blog >>>

In MySQL, tables are used to store data in a structured format. In this article, we will learn how to create a table in MySQL.


Before we begin, you should have the following:

  • A database in which to create the table
  • Administrative privileges to create tables in the database

Creating a Table

To create a new table in MySQL, follow these steps:

  1. Open the MySQL client.
  2. Log in to the MySQL server using the following command:
mysql -u username -p

Replace __username` with your MySQL username. You will be prompted to enter your password.

  1. Once you are logged in, select the database in which you want to create the table:
USE dbname;

Replace __dbname` with the name of the database in which you want to create the table.

  1. Create a new table using the following command:
CREATE TABLE tablename (
column1 datatype constraints,
column2 datatype constraints,
columnN datatype constraints

Replace __tablename with the name you want to give to your table. Replace __column1, __column2, and so on with the names of the columns you want to create. Replace __datatype with the data type of the column. Replace __constraints with any additional constraints you want to add, such as __NOT NULL or __UNIQUE`.

  1. Verify that the table has been created by using the following command:

This will display a list of all the tables in the selected database, including the one you just created.

Create Tables and Visually Manage MySql using DbSchema

DbSchema is a MySQL client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.

Create Table >

Create Table

Start the application and connect to the MySQL database. Right-click the table folder to create a table.

Add Columns >

Add Table Columns

Add the columns to the table.


Creating a table in MySQL is a simple process. You just need to select the database in which you want to create the table and use the __CREATE TABLE` command to define the columns and data types for the table.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.