MySQL - How to Insert Data?

MySQL: How to Insert Data into a Table

In MySQL, tables are used to store data in a structured format. Once you have created a table, you can insert data into it. In this article, we will learn how to insert data into a table in MySQL.


Before we begin, you should have the following:

  • A database with a table in which to insert data
  • Administrative privileges to insert data into the table

Inserting Data into a Table

To insert data into a 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 the table is located:
USE dbname;

Replace dbname with the name of the database that contains the table.

  1. Insert data into the table using the following command:
INSERT INTO tablename (column1, column2, ..., columnN) VALUES (value1, value2, ..., valueN);

Replace tablename with the name of the table into which you want to insert data. Replace column1, column2, and so on with the names of the columns in the table. Replace value1, value2, and so on with the values you want to insert into the columns.

  1. Verify that the data has been inserted into the table by using the following command:
SELECT * FROM tablename;

This will display all the data in the selected table.

Insert Data 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.

Insert Data using Relational Data Explorer alt >

Insert Data using Relational Data Explorer

Open the Relational Data Explorer from the DbSchema Editors menu. Press the ‘+’ icon on the table bottom bar to insert new data records.

Insert Data using SQL Editor >

Insert Data using the SQL Editor

Right-click any table header in the layout and choose Build SQL / Insert Data.

Import the Data using the Data Loader alt >

Import the Data using the Data Importer

Choose Tools / Data Importer from the DbSchema menu. Choose the file to import ( can be CSV, XML or Excel).

Import Data alt >

Data Importer - Choose and Edit the Target Columns

We can change the data type and the length.

Insert Data choose Data Type alt >

Data Importer - Edit the Column Data Type and Length

We can change the data type and the length.

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys.

Query Builder alt >

Query Builder

Create SQL Queries using the mouse.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries

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.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme.


Inserting data into a table in MySQL is a simple process. You just need to select the database that contains the table and use the INSERT INTO command to specify the values you want to insert into the columns of the table