MySQL - How to insert data in bulk into a table?
The most basic way to insert multiple columns:
INSERT INTO table_name (col1, col2, col3)
VALUES
(value1, value2, value3),
(value4, value5, value6),
(value7, value8, value9);
If you have a data in a text file, each value is separated by a comma, each line is one data set, use LOAD DATA INFILE as below:
LOAD DATA INFILE '/path/to/file.txt' INTO TABLE table_name
FIELDS TERMINATED BY ',',
LINES TERMINATED BY '\n';
Assuming that you have the first line as the header, you need to skip importing it:
LOAD DATA INFILE '/path/to/file.txt' INTO TABLE table_name
FIELDS TERMINATED BY ',',
LINES TERMINATED BY '\n'
IGNORE 1 LINES;
You can read more from the documentation.
Need a good GUI Tool for MySQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.
