DbSchema Database Designer

DbSchema | How to import a CSV file in MySql

Publish on DbSchema Blog >>>

1.Using SQL

Importing a csv file to your MySQL database is very simple. In this article, I’m going to show you two ways to do this.

In this example I will use a file stored in C:/Temp, named product.csv. This file contains 3 items for the __product` table and it looks like this:


The first row contains the column names and the rest product properties.

First of all, you have to enter the MySQL shell and select the database. In order to do this, you have to:

  1. Open the command line by typing __cmd` in Start;

  2. Execute the next query:

    mysql.exe -u root -p

After you insert the password you are ready to import your

  1. Execute __SHOW DATABASES` in order to see all your databases;
  2. Then, execute __USE database_name` to select the desired database;
  3. If you want to see what tables are in the database, execute __SHOW TABLES`.

If everything worked, you can now execute the query that will import the data from the file:

 LOAD DATA LOCAL INFILE 'C:/Temp/product.csv' 
 INTO TABLE product 
 (id, name, price);

Now, let’s break this query to understand better what’s happening:

  • LOCAL tells the database that the file is expected to be found locally;
  • FIELDS TERMINATED BY ‘,’’ specifies that the comma is the delimiter;
  • IGNORE 1 ROWS tells the database to ignore the first row from the document, the one that specifies column names.

To check if the data was imported correctly, execute:

 SELECT * FROM table_name;

2.Using DbSchema

With DbSchema, importing a CSV file is way more easier. First, you have to access the Data Importer from the top menu Data Tools > Import Data From File.

data importer

From the data importer you can select the file, the schema and the table. Next, you can modify the settings for date, columns (you can choose if what columns to load) and more.

importer settings

To verify if the data was imported correctly, press on the table header while holding CTRL + SHIFT.

That’s all. If you want to try DbSchema, download it here

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.