DEV Community

Cover image for Import CSV file using MariaDB CLI
Sergio Peris
Sergio Peris

Posted on • Originally published at sertxu.dev

Import CSV file using MariaDB CLI

If we have a CSV file, we can import the data to a database using the following command:

LOAD DATA INFILE '/home/sertxu/Desktop/users.csv'
INTO TABLE users
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
Enter fullscreen mode Exit fullscreen mode

This command will get the file located at /home/sertxu/Desktop/users.csv and import its content into the table users ignoring the first line in the CSV file.

If your file doesn't contains the headers in the first row of the file, you can remove the IGNORE 1 ROWS from the command before executing it.

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay