mycat ERROR 1064 (HY000): ReplaceStatement can't be supported

mycat 不支持replace语法，怎么办呢？

mysql> replace into test(id,name) values(1,'a');

ERROR 1064 (HY000): ReplaceStatement can't be supported,use insert into ...on duplicate key update... instead

根据提示，使用insert into  ... on duplicate key 

mysql> insert  into test(id,name,age) values(1,'a',20) ON DUPLICATE KEY UPDATE age=30;

Query OK, 1 row affected (0.01 sec)

参考文档：

http://dev.mysql.com/doc/refman/5.6/en/insert-on-duplicate.html