Question

SQL 提示缺失右括号

update t_card_in_cabin_info tcici
set card_num = ((select card_num
from t_card_in_cabin_info ,t_libr_info
where cabin_id=1 and libr_id=1 and card_type=1)+100)
where cabin_id=1 and card_type=1

总是提示缺失右括号！请高手指教

Answer 1

update t_card_in_cabin_info tcici
set card_num = (select card_num +100
from t_card_in_cabin_info ,t_libr_info
where cabin_id=1 and libr_id=1 and card_type=1)
where cabin_id=1 and card_type=1
试试看

追问

这样运算后的结果是将原来的card_num 值加100后更新吗？（SQL初学者，请见谅~~~）

Answer 2

update的表名别名去掉 后面子查询 又没用到
update t_card_in_cabin_info
set card_num = (select card_num
from t_card_in_cabin_info ,t_libr_info
where cabin_id=1 and libr_id=1 and card_type=1)+100
where cabin_id=1 and card_type=1

sql2005下通过语法检查

追问

按你的方法操作了，但去掉select最外面的括号和去掉别名后，报错说SQL命令未正确结束。