Two methods available to insert records into the database
First one is the LOAD DATA INFILE syntax. In this method,
results are either written to a text file or a common separated
file (CSV) where fields are delimited by a tab space in text file
or a comma in a CSV file. The data written will then be
exported using the LOAD DATA INFILE into the tables. The
second method is to insert data by batches. The syntax is
shown below: