What is load data infile?

Question

You can use the LOAD DATA INFILE command to import a CSV file into a table. Check the link MySQL - LOAD DATA INFILE. LOAD DATA LOCAL INFILE 'abc.csv' INTO TABLE abc FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY ' ' IGNORE 1 LINES (col1, col2, col3, col4, col5. ); 2 янв. 2013 г.

How does load data infile work?

The LOAD DATA statement reads rows from a text file into a table at a very high speed. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. LOCAL also affects data interpretation and error handling. LOAD DATA is the complement of SELECT ...

What is load data infile in MySQL?

In MySQL database (or MariaDB), using “load data infile” command, you can upload data from a text file to tables. The load data infile command provides several flexible options to load various formats of data from text file to tables.

What is local Infile?

In contrast, when you execute the LOAD DATA LOCAL INFILE statement, the client attempts to read the input file from its file system, and it sends the contents of the input file to the MariaDB Server. This allows you to load files from the client's local file system into the database.

How do I enable local data Infile?

To disable or enable it explicitly, use the --local-infile=0 or --local-infile[=1] option. For the mysqlimport client, local data loading is not used by default. To disable or enable it explicitly, use the --local=0 or --local[=1] option.

Expert · Answer