mysql> load data local infile '/tmp/BS_X1.xlsx' into table BS_PROPERTY fields terminated by ',' lines terminated by '\n';
ERROR 1300 (HY000): Invalid utf8mb4 character string: 'PK'
mysql>
【解决办法】:
讲'/tmp/BS_X1.xlsx'的文件格式变换成utf8即可。
mysql> load data local infile '/tmp/BS_X1.xlsx' into table BS_PROPERTY fields terminated by ',' lines terminated by '\n';
ERROR 1300 (HY000): Invalid utf8mb4 character string: 'PK'
mysql>
【解决办法】:
讲'/tmp/BS_X1.xlsx'的文件格式变换成utf8即可。