Mysql text file import and batch processing mode application Instructions _mysql

1 loading records in a text file into a MySQL database table
(1) Text file format: One record per line, the field values are separated by the tab locator, the field order is the same as the order in the table definition, and the indeterminate field values are represented by \ n;
(2) LOAD DATA local INFILE ' pet.txt ' into TABLE pet;
Note: If you are using a Windows editor, you should use the following:
LOAD DATA local INFILE ' pet.txt ' into TABLE pet
LINES terminated by ' \ r \ n ';

Running MySQL in 2 batch mode
(1) Put the MySQL statement you want to run in a text file batch-file.txt;
(2) Implementation: Mysql-h Host-u user-p < batch-file.txt;
(3) Redirect output to file OUT.txt:
Mysql-h host-u user-p < batch-file.txt > out.txt;
To run a script from the MySQL prompt:
Mysql> source Batch-file.txt, or mysql> \. Batch-file.txt;