Posts

Showing posts from May, 2017

checking coloumName value before update. if value of coloumName = 1 then 0,if coloumName = 0 then 1.

UPDATE `tableName ` SET ` couloumName `= IF (coloumName = 1 , 0 , 1 ) WHERE id = Idvalue