MySQL - How to Insert Data?

---

MySql • 09-May-2023

---

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.

Prerequisites

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.

3. 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.

4. 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.

5. 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

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 the SQL Editor

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

---

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).

---

Data Importer - Choose and Edit the Target Columns

We can change the data type and the length.

---

Data Importer - Edit the Column Data Type and Length

We can change the data type and the length.

---

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams.

---

Simple Connection Dialog

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

---

Relational Data Explorer

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

---

Query Builder

Create SQL Queries using the mouse.

---

SQL Query Editor

Edit and execute SQL Queries

---

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

Configurable styles & dark theme.

---

Conclusion

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