请问mysqlwriter支持update语句吗,update多条件
Open
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
场景是这样的,需要同步表A到表B,反过来也需要同步,也就是双向同步,如果仅仅一个id的话会导致死循环,因为select是根据更新字段查询数据的,这样被更新后马上就会被查出来,比如A查询出数据去更新B,此时B也会被查询出来,然后又去更新A,导致死循环问题,我是想在update的时候加一个更新时间判断,但是发现mysqlwriter是insert into on update,不支持update的where条件
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the mysqlwriter implementation and its handling of INSERT ... ON DUPLICATE KEY UPDATE. Determine how update conditions would be configured and applied for bidirectional synchronization, then add coverage for multi-condition updates and verify that the resulting behavior avoids the reported loop.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100