You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/07/21 06:31:38 UTC

[GitHub] [shardingsphere] 1048933788 opened a new issue, #19417: How to associate updates

1048933788 opened a new issue, #19417:
URL: https://github.com/apache/shardingsphere/issues/19417

   ## Question
   
   **How to associate updates**
   **version** 4.0.1
   **for example：**
   UPDATE table1 t1,
   table2 t2 
   SET t1.source_ext_a = t2.source_ext_a,
   t1.source_ext_b = t2.source_ext_b,
   t1.scene_code = t2.scene_code,
   t1.source = t2.source,
   t2.member_clean_status = 1 
   WHERE
   	t1.id = t2.id 
   	AND t1.channel = t2.channel 
   	AND t2.id >= 1 
   	AND t2.id <= 1000000
   	LIMIT 1
   
   **exception** :  Cannot support Multiple-Table for '%s'.
   
   最好能用中文回我哈哈，多谢啦


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] TeslaCN commented on issue #19417: How to associate updates

Posted by GitBox <gi...@apache.org>.

TeslaCN commented on issue #19417:
URL: https://github.com/apache/shardingsphere/issues/19417#issuecomment-1191152895

   ShardingSphere 4.1.1 is no longer maintained, please try the latest version.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu closed issue #19417: How to associate updates

Posted by GitBox <gi...@apache.org>.

terrymanu closed issue #19417: How to associate updates
URL: https://github.com/apache/shardingsphere/issues/19417


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org