jdbc connectors

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

jdbc connectors

liujian
Hi:
  想咨询下 jdbc connectors  sink到mysql的是否设置了主键, 请问走的语法是 replace into语法吗,还是其他语法,我观察过mysql表中id是没有变化的,但是 AUTO_INCREMENT 属性会增加2
Reply | Threaded
Open this post in threaded view
|

Re: jdbc connectors

guoyb
不是replace,用的是insert into duplicate key update



---Original---
From: "liujian"<[hidden email]&gt;
Date: Thu, Apr 1, 2021 16:02 PM
To: "user-zh"<[hidden email]&gt;;
Subject: jdbc connectors


Hi:
&amp;nbsp; 想咨询下 jdbc connectors&amp;nbsp; sink到mysql的是否设置了主键, 请问走的语法是 replace into语法吗,还是其他语法,我观察过mysql表中id是没有变化的,但是&amp;nbsp;AUTO_INCREMENT 属性会增加2