数据库中更新标志字段的快速方法

1. UPDATE table SET field = !field WHERE …
2. UPDATE table SET field = ABS(field-1) WHERE …

需要注意的是 filed 属性需要为 not null

Post a Comment

Your email is never published nor shared. Required fields are marked *