The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Load multiple Files

Hello everybody, Is there a possibility to use a filelist (containing several filenames) instead of 'file_name', and to go through this list by loop? I have a folder with about 500 files (*.csv), and I try to load the data by Looping.

LOAD DATA INFILE 'file_name'

Best regards Jacob

Answer Answered by Daniel Black in this comment.

If there are going to the same table, then consecutive LOAD DATA INFILE will results int the same performance and can be done in a shell script or any basic programming language.

There is no multiple file syntax.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.