DbSchema | MySQL - How to Insert Data?

Publish on DbSchema Blog >>>

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.

---

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