MySQL Loading text data

The data inside the text must be separated by the TAB key, and if you need to represent a null value, use \ n to indicate

The database field needs to correspond to the Text tab-key separation as follows:

table field Name,cat

LISI \ n

Zhangsan m

In the database, as in the following method:

LOAD DATA LOCAL INFILE '/path/data.txt ' into TABLE tablename LINES TERMINATED by ' \ r \ n ';

LINES TERMINATED by ' \ r \ n ' for the specified line delimiter default ' \ n ' (that is, the Linux line delimiter), if your machine is an Apple system, please use ' \ r '

This article is from the "Linux Learning path" blog, so be sure to keep this source http://raystudylinux.blog.51cto.com/9065684/1765678

MySQL Loading text data