2009-11-16

conditional statements mysql

shortie on conditional statements with update. useful!

CREATE TABLE `table` (
`id` int(11) NOT NULL,
`text` varchar(255) default NULL,
`int` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


UPDATE table SET `int` = IF(`int`='0','1','0') WHERE id =1 

No comments:

Post a Comment