kattle 同步数据 - 只增加、无更新、无删除

获取最大 ID


SELECT MAX(ID) FROM
(SELECT MAX(ID) AS ID FROM kettle UNION ALL SELECT 0 AS ID FROM DUAL) as t1

表输入


SELECT
 *
FROM kettle

where id > ?

插入 / 更新

比较中 只比较 id