MySQL Load data InFile outfile Import Export

Let's take a look at the MySQL Load data InFile outfile Import Export Oh, this is the way we run the Windows Cmd.exe and then use the following statement in the DOS command method.

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

Commonly used as follows:
Load Data InFile ' c:/data.txt ' into the Table ' Tabletest ' Lines terminated by ' RN ';
This statement, the fields are separated by tabs by default, each record is separated by a newline character, and the line break is "RN" under Windows.
The contents of the C:/data.txt file are two lines:
2 b
1 A
There is a tab between "1" and "a"
This leads to two records.