mysql字段:
permission set('test1','test2','test3','test4','test5','test6','test7','test8','test9')
说明:
2 的 N(第几位,0开始算)次方
添加对应2和4的set值:2 = 2的1(第1个,0开算)次方
操作:
UPDATE info SET `permission`=`permission` &~1 WHERE id = 1;//去掉第一个
UPDATE info SET `permission`=`permission` &~2 WHERE id = 1; //去掉第二个
...
UPDATE info SET `permission`=`permission` &~256 WHERE id = 1;//去掉第九个
UPDATE info SET `permission`=`permission` |2|4 WHERE id = 1//勾选