Usage of MySQL Load Data InFile _mysql

First create a table
Use Test;
Create Table Tabletest (
' ID ' Mediumint (8) Default ' 0 ',
' Name ' varchar default '
) Type=myisam;


Import data to a datasheet
Load Data InFile ' c:/data.txt ' into Table ' tabletest '


Commonly used as follows:
Load Data InFile ' c:/data.txt ' into Table ' tabletest ' Lines terminated by ' \ r \ n ';
This statement, the fields are separated by tabs by default, each record is separated by a newline character, and the line break is "\ r \ n" under Windows.

The contents of the C:/data.txt file are two lines:
1 A
2 B
There is a tab between "1" and "a"
This leads to two records.



Custom syntax
Load Data InFile ' c:/data.txt ' to Table ' Tabletest ' Fields terminated by ', ' enclosed by ' "' escaped by '" ' Lines Ated by ' \ r \ n ';

Fields terminated by ', ' enclosed by ' "' escaped by '" '
Indicates that each field is separated by commas and the contents are enclosed in double quotes

Lines terminated by ' \ r \ n ';
Indicates that each piece of data is separated by a newline character.


The opposite of the Load Data InFile is
Select * from ' tabletest ' into outfile ' c:/data_outfile.txt ';
Export the data of a table