文档解释Errornumber:MY-010218;Symbol:ER_LOAD_DATA_INFILE_FAILED_IN_UNEXPECTED_WAY;SQLSTATE:HY000Message:LOADDATAINFILEinthereplicaSQLThreadcanonlyreadfrom–rep...

1、常用如下：LoadDataInFile'C:/Data.txt'IntoTable`TableTest`LinesTerminatedBy'';这个语句，字段默认用制表符隔开，每条记录用换行符隔开，在Windows下换行符为“”C:/Data.txt文件内容如下面两行：1A2B“1”和“A”之间有一个制表符这样就导...

LOADDATA[LOW_PRIORITY|CONCURRENT][LOCAL]INFILE'file_name.txt'[REPLACE|IGNORE]INTOTABLEtbl_name[FIELDS[TERMINATEDBY'string'][[OPTIONALLY]ENCLOSEDBY'char'][ESCAPE...