toggle tinyint / integer / number / binary
Posted March 25th, 2009 by WilliamCarrier
Log from IRC server Freenode (IPv6) channel #SQL.
This is a spiritual successor of flag, status, binary, on/off, yes/no, enum, ...
| <me> | I have a tinyint status field that will contain either 0 or 1, is there a command that could toggle between them or do I need to do that programmatically ? |
| <gtowey> | me: IF(status=1,0,1) |
| <FurnaceBoy> | gtowey, or just 'status<>1' |
| <gtowey> | FurnaceBoy: good point |
| <me> | gtowey: what would be an update command with IF(status=1,0,1) ? UPDATE table SET status=IF(status=1,0,1) WHERE ID=X ? |
| <FurnaceBoy> | or... status = NOT status |
| <me> | FurnaceBoy: thanks :) |
| <FurnaceBoy> | me, np |
