Toggling a MySQL TinyInt Column - Lampwrights Forum

		Lampwrights Forum > Linux, Apache, MySQL, PHP > MySQL
-- Toggling a MySQL TinyInt Column

Mark Forums Read

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

Tags

mysql queries

,

other mysql

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

All times are GMT -4. The time now is 09:17 PM.