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

[Feature] support update/delete shardingTable with join globalTable #3738

Closed
dcy10000 opened this issue Jun 16, 2023 · 0 comments · Fixed by #3669, #3672, #3676, #3677 or #3680
Closed

[Feature] support update/delete shardingTable with join globalTable #3738

dcy10000 opened this issue Jun 16, 2023 · 0 comments · Fixed by #3669, #3672, #3676, #3677 or #3680
Assignees
Milestone

Comments

@dcy10000
Copy link
Member

dcy10000 commented Jun 16, 2023

https://actiontech.github.io/dble-docs-cn/3.SQL_Syntax/3.2_DML/3.2.04_UPDATE.html
https://actiontech.github.io/dble-docs-cn/3.SQL_Syntax/3.2_DML/3.2.03_DELETE.html

you can use sql like this. as long as the shardingNodes of global2 contains all of the shardingNodes of sharding_2_t2.

update sharding_2_t2 a set name=1 where a.id= (select id from global2 b  where a.id=b.id);
@dcy10000 dcy10000 added this to the 3.23.04.0 milestone Jun 16, 2023
@dcy10000 dcy10000 self-assigned this Jun 16, 2023
@dcy10000 dcy10000 changed the title [Feature] support update/delete shardingtable with join globaltable [Feature] support update/delete shardingTable with join globalTable Jun 16, 2023
@wenyh1 wenyh1 closed this as completed Jun 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment