For example, you can use COMMIT statements like so: SET autocommit=0 But once you have the need to quickly import data into your database instances, you have a couple of other options too. Well, we haven’t covered everything!įor example, we told you that LOAD DATA INFILE is faster, and it is.

Now we could tell you that “no, LOAD DATA INFILE is not the only option when importing data into MySQL or MariaDB-based instances” and leave it at that, however, that’s not what you’re here for – you’re here to know the best mechanism to use for importing your data into MySQL-based instances.īy now you know that LOAD DATA INFILE and INSERT INTO are your only options – however, you might also know that we have covered some of the functionalities provided by LOAD DATA INFILE in an earlier blog post of ours, so you might wonder why we are writing another one. One can also use LOAD DATA INFILE and specify a specific file where he or she wants to load data from into a given table.One can use INSERT INTO and specify a table name along with the columns and data one needs to import into a given database instance.What options are there?įirst of all, when it comes to importing data into MySQL, you have a couple of options to import data: In this blog, we will look through the options you have when it comes to importing data into your MySQL instances.

If you are a developer or database administrator that wants to load the data into your databases quickly, you probably already know that you have quite a few options, at least as far as MySQL is concerned.

Mysql import data from csv