用datax抽取mysql的数据报错:
check the manual that corresponds to your MySQL server version for the right syntax to use near 'explain,0x09,''),0x0a,''),0x0d,''),REPLACE(REPLACE(REPLACE(phone,0x09,''),0x0a,'' at line 1
看能有如下问题:
1.sql字段中与关键字冲突,如explain、desc等
解决办法:在sql将关键字字段用分隔符``包起来即可
如:select `explain` from ...
2.sql中存在中文字符,一般是字段为中文时会报错,改掉即可。