Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DataX MysqlWriter 中的writeMode 问题 #2234

Open
RaiseWwb opened this issue Nov 4, 2024 · 1 comment
Open

DataX MysqlWriter 中的writeMode 问题 #2234

RaiseWwb opened this issue Nov 4, 2024 · 1 comment

Comments

@RaiseWwb
Copy link

RaiseWwb commented Nov 4, 2024

DataX MysqlWriter 中的writeMode 中的update 为何不生效

                    "writeMode": "update",
                    "onDuplicateKey": {
                        "column": [
                           "`type`",
                           "`school_id`",
                           "`school_name`",
                           "`count`"
                        ]

我这样写了 为何 相同的数据写入到 目标表 数据是累加的 不是通过这几个字段更新

@zhangkuantian
Copy link

貌似需要在建表的时候指定 UNIQUE KEY

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants