LOAD DATA [LOW_PRIORITY | CONCURRENT] [L

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ‘file_name.txt’
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY ‘\t’] – 在字段之间写入制表符
[[OPTIONALLY] ENCLOSED BY ‘’] --不把字段包含在任何引号字符中。如果是ENCLOSED BY “’” ：使用单引号把各个字段括起来；
[ESCAPED BY ‘\’ ] --当字段值中出现制表符、新行或‘\’时，使用‘\’进行转义。
]
[LINES
[STARTING BY ‘\n’] – 在行的末端写入新行。
[TERMINATED BY ‘’] --不会跳过任何行前缀。
]
[IGNORE number LINES]
[(col_name_or_user_var,…)]
[SET col_name = expr,…)]

SELECT * INTO outfile ‘e:/tmp/t_aty_corp.sql’ FIELDS TERMINATED BY ‘$’ OPTIONALLY ENCLOSED BY “’” ESCAPED BY ‘\’ LINES STARTING BY ‘\r\n’ TERMINATED BY ‘’ FROM db_aty.t_aty_corp;

‘1100’${}^{\prime }监狱管理{局}^{\prime }$\N$1$\N$‘监狱管理局’$1$1$’1100’${}^{\prime }{1}^{\prime }$\N${}^{\prime }2011-01-1200:00:00^{\prime }$
‘1101’${}^{\prime }第一监{狱}^{\prime }$‘1100’$2$\N$‘第一监狱’$1$2$’1101’${}^{\prime }{1}^{\prime }$\N${}^{\prime }2011-01-1200:00:00^{\prime }$
‘1102’${}^{\prime }第二监{狱}^{\prime }$‘1100’$2$\N$‘第二监狱’$1$3$’1102’${}^{\prime }{1}^{\prime }$\N${}^{\prime }2011-01-1200:00:00^{\prime }$

SELECT * INTO outfile ‘e:/tmp/t_aty_corp.sql’ FIELDS TERMINATED BY ‘$’ OPTIONALLY ENCLOSED BY “^” ESCAPED BY ‘\’ LINES STARTING BY ‘\r\n’ TERMINATED BY ‘’ FROM db_aty.t_aty_corp;

¹¹⁰⁰KaTeX parse error: Expected group after '^' at position 7: ^监狱管理局^̲\N$1$\N$^{监狱管理局}$1$1$¹¹⁰⁰KaTeX parse error: Double superscript at position 3: ^1^̲\NKaTeX parse error: Expected group after '^' at position 21: …-01-12 00:00:00^̲
¹¹⁰¹KaTeX parse error: Expected group after '^' at position 6: ^第一监狱^̲¹¹⁰⁰$2$\N$^第一监狱$1$2$¹¹⁰¹KaTeX parse error: Double superscript at position 3: ^1^̲\NKaTeX parse error: Expected group after '^' at position 21: …-01-12 00:00:00^̲
¹¹⁰²KaTeX parse error: Expected group after '^' at position 6: ^第二监狱^̲¹¹⁰⁰$2$\N$^第二监狱$1$3$¹¹⁰²KaTeX parse error: Double superscript at position 3: ^1^̲\NKaTeX parse error: Expected group after '^' at position 21: …-01-12 00:00:00^̲