What value could I insert into a bit type column?

Generally speaking, for boolean or bit data types, you would use 0 or 1 like so:

UPDATE tbl SET bitCol = 1 WHERE bitCol = 0

See also:

• Which MySQL data type to use for storing boolean values
• How do you create a yes/no boolean field in SQL server?