Toggling a MySQL TinyInt Column

Jeff · 02-23-2011, 11:10 AM

This query:

Code:

UPDATE table set field= 1 - field

Will toggle a tinyint (boolean) column in MySQL. Note, that field should have a default value of either 0 or 1 but not NULL.

Gavinplato · 01-28-2024, 04:38 AM

Have you encountered any specific challenges or considerations when toggling MySQL TinyInt columns using this query, especially regarding the default value of the 'field' column?

02-23-2011, 11:10 AM	#1
Jeff Administrator Join Date: Jul 2010 Posts: 402 Rep Power: 10	Toggling a MySQL TinyInt Column This query: Code: UPDATE table set field= 1 - field Will toggle a tinyint (boolean) column in MySQL. Note, that field should have a default value of either 0 or 1 but not NULL.
	Reply With Quote

01-28-2024, 04:38 AM	#2
Gavinplato Junior Member Join Date: Jan 2024 Posts: 1 Rep Power: 0	Have you encountered any specific challenges or considerations when toggling MySQL TinyInt columns using this query, especially regarding the default value of the 'field' column?
	Reply With Quote

mysql queries

other mysql