java mysql 插入 重复_使用coalesce()在重复键更新上插入MySQL会在java中调用语法错误...

我试图做一个更新，保存旧值，如果新的是NULL，SQL查询是

INSERT INTO scheme (id,type)

VALUES (1,1) ON DUPLICATE KEY

UPDATE scheme

SET type=COALESCE(1,type)

WHERE id=1错误文字是

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET type=COALESCE(1,type)

WHERE id=1' at line 4

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)我想这只是一些显而易见的事情，但我无法弄清楚:(