意外令牌：内部必需：设置：线：2

发布于 2025-01-19 08:34:27 字数 525 浏览 3 评论 0原文

当值退出另一个表（tblStructure_merged_new）中时，我正在尝试更新表（tblinstructures.state）中的列。但是更新内部联接无效。

UPDATE `tblStructures` 
INNER JOIN tblStructures_merged_new ON `tblStructures`.`Hole` =tblStructures_merged_new.`Hole` 
SET `tblStructures`.`State`  = '0' 
WHERE `tblStructures`.`From_m`= tblStructures_merged_new.`From_m` 
AND `tblStructures`.`Struct1`  = tblStructures_merged_new.`Struct1`;

错误消息是

sql错误[42581]：ucaexc :::: 5.0.1意外令牌：内部必需：集：线：2

关于为什么不起作用的任何想法？

原文

I am trying to update a column in a table (tblStructures.State) when the values exit in another table (tblStructure_merged_new). But the update inner join did not work.

UPDATE `tblStructures` 
INNER JOIN tblStructures_merged_new ON `tblStructures`.`Hole` =tblStructures_merged_new.`Hole` 
SET `tblStructures`.`State`  = '0' 
WHERE `tblStructures`.`From_m`= tblStructures_merged_new.`From_m` 
AND `tblStructures`.`Struct1`  = tblStructures_merged_new.`Struct1`;

The error message is

SQL Error [42581]: UCAExc:::5.0.1 unexpected token: INNER required:
SET : line: 2

Any ideas of why is not working?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

じ违心 2025-01-26 08:34:27

切换行顺序

UPDATE `tblStructures` 
SET `tblStructures`.`State`  = '0' 
FROM `tblStructures`
INNER JOIN tblStructures_merged_new ON `tblStructures`.`Hole` =tblStructures_merged_new.`Hole` 
WHERE `tblStructures`.`From_m`= tblStructures_merged_new.`From_m` 
AND `tblStructures`.`Struct1`  = tblStructures_merged_new.`Struct1`;

Switch order of lines

UPDATE `tblStructures` 
SET `tblStructures`.`State`  = '0' 
FROM `tblStructures`
INNER JOIN tblStructures_merged_new ON `tblStructures`.`Hole` =tblStructures_merged_new.`Hole` 
WHERE `tblStructures`.`From_m`= tblStructures_merged_new.`From_m` 
AND `tblStructures`.`Struct1`  = tblStructures_merged_new.`Struct1`;

回复收藏 0 原文

~没有更多了~