Problems and workarounds for MySQL importing TXT files using load

• Import TXT file with Import Wizard this way:

• Alternatively, you can import it using the Load method. At the very beginning, insert with the following code:

Load ' F:\\data\\predict_data.txt '    into Table Weibo_predict_data   (id,uid,mid,time,forward_count,comment_count,like_count,content);

Due to the error "[ERR] 1300-invalid UTF8 character string:". Causes the operation to fail. Access information:

Therefore, the code is modified to:

Load ' F:\\data\\predict_data.txt '    into Table Weibo_predict_data    character Set GBK   (id,uid,mid,time,forward_count,comment_count,like_count,content);

can be imported successfully.

Problems and workarounds for MySQL importing TXT files using load