How I Import Any CSV File into MySQL/MariaDB Database

Quick technique on how to easily import CSV files into a MySQL/MariaDB database table. We use a database management tool called HeidiSQL to import the CSV data into a temp table. Then we'll use simple data transformation with INSERT-SELECT SQL statements to copy the data from the temp table to the target table.

0:00 Overview
0:38 Import CSV to a temp table
2:24 INSERT-SELECT SQL from temp table to target table

[torutomaktu]

how can i upload multiple CSVs at once?