Database Reference
In-Depth Information
Summary
Although you may rarely use the
LOAD DATA INFILE
statement, when you need it and
use it, you'll find that it saves you plenty of time. It makes bulk importing of data and mi-
grating to MySQL and MariaDB much easier. Because the layout of data text files can vary
so much, you might need a few attempts to load data properly. But as long as you create a
temporary import table, you can keep deleting the data and trying again without disturbing
anyone else or risking the loss of other data.
The
SELECT...INTO OUTFILE
statement is an excellent method for sharing data with
others. It may become a regularly used tool for you if you work in an organization that
shares data with other organizations. So at least be very familiar with it in case your situ-
ation calls for it.
