This article mainly describes how to load data using MySQL loaddata. The proportion of applications that load data using MySQL loaddata is still the majority. If you use this newly developed technology, if you are curious, the following articles will unveil its mysteries.
1. This method is used because of a collection system. The number of records collected each day reaches. Loading of one entry is slow. The loading speed cannot keep up with the collection speed. Therefore, this method is used.
Enter the database and enter:
Java code
- load data local infile 'd:\loaddata.txt' into table detail fields terminated by ',' LINES terminated by '\n';
- load data local infile 'd:\loaddata.txt' into table detail fields terminated by ',' LINES terminated by '\n';
''D: \ loaddata.txt '-------- indicates the absolute path of loaddata.txt
',' -------- Indicates that fields are separated.
'\ N' indicates -------- indicates that records are separated by' \ n. That is, one row and one record
2. Use MySQL's navicat8 to import and export data directly.
The above content is a description of how MySQL loaddata loads data. I hope it will help you in this regard.