The load data infile statement reads a table from a text file at a high speed. If you specify the local keyword, read the file from the client host. If local is not specified, the file must be on the server. (Local is available in MySQL 3.22.6 or a
The LOAD DATA infile statement reads from a text file into a table at a high speed. If you specify the local keyword, read the file from the client host. If local is not specified, the file must be located on the server. (Local is available in MySQL3
Load data [low_priority] [local] infile 'file_name.txt '[Replace | ignore]
Into Table tbl_name[Fields[Terminated by '\ T'][Optionally] enclosed by ''][Escaped by '\'][Lines terminated by '\
If you want to import Chinese data, the utf8 Character Set set in mysql will save the UTF-8 character set for the xxx.txt file you want to import. The command load data infile "d: /Websites/Sxxxx/test1.txt "ignore into table 'names' fields
The MySQL load method must be built in case the MySQL service allows the command to be used:How to open the command:1. Add a row local-infile=1 (the default appears to be on) to the MY.CNF (Windows My.ini) for the instance , and switch to 0 to OFF,
If you are importing the Chinese data, my MySQL set UTF8 character set, so you want to import the Xxx.txt file to save the Utf-8 character set, command load Data infile "D:/websites/sxxxx/test1.txt" Ignore into table ' names ' fields terminated by ',
[MySQL practice] when loading data infile reports ERROR 1148 (42000) or ERROR 1045 (28000, load data infile is a very efficient command, from db1.table1 of host1 Through select... into outfile: import data to a text file, and then import data to db2.
Mysql import data load data infile usage, mysqlinfile
Mysql import data load data infile usageBasic Syntax: load data [low_priority] [local] infile 'file _ name txt '[replace | ignore]
Into table tbl_name
[Terminated by 'T']
Use load data Infile in mysql, mysqlinfileThe speed is 20 times faster than insert. Share java program operations.
package com.mysql.csv;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
and provide relevant evidence. A staff member will contact you within 5 working days.