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.
Comments
Comments loading...
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.
