https://segmentfault.com/q/1010000004434035/a-1020000004434188
总结:
update table_name set field1=value1 and field2=value2 where ...;
等同于 update table_name set field1=(value1 and field2=value2) where ...;
括号内应该是个布尔类型结果,如果field是int类型,则结果为0或1
https://segmentfault.com/q/1010000004434035/a-1020000004434188
总结:
update table_name set field1=value1 and field2=value2 where ...;
等同于 update table_name set field1=(value1 and field2=value2) where ...;
括号内应该是个布尔类型结果,如果field是int类型,则结果为0或1
本文标题:update在set多个字段时用and关联
本文链接:https://www.haomeiwen.com/subject/qvjviftx.html
网友评论