I use a SET Value to keep track of my Replication Process on the Main-Daemon.
So for every Daemon, how collects Data from a Branch, a have a Flags
as a SET ('daemon_on', 'slave_working', ...)
Now I wont to toggle only one Bit and lave the rest at it is.
Example:
Now I would like to toggle Bit 1 (slave_working) without to check first if Bit 0 (daemon_on)
is set or not.
(I know the Slave can't work if the daemon is off, but there are more Options)
Is there a way to set/reset only one Bit in a SET Value.
I couldn't find something useful in the Docs.
Maybe I can link the Update Values with an XOR and a Mask, but how must I do it in MySQL?
Up to now a haven’t figured it out how to UPDATE a SET Value with a "binary Value".
I use only the "Strings" or the "Decimal Value".
Thanks if someone is a little bit more familiar with SET Values and posts a short comment.
MfG, Tobias
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
