How to insert value for bit column of mysql

Question

I want to insert the value into a bit type column in MySQL. But I am getting a data truncation error.

CREATE TABLE `BITTESTTABLE` (
  `db_field` varchar(50) NOT NULL,
   `is_editable` bit(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1

If I am inserting a row with

INSERT INTO BITTESTTABLE values('XYZ','0')

I am getting

Data too long for column 'is_editable' at row 1

So how do I insert the data for bit type column?

Answer 1

You should use:

INSERT INTO `BITTESTTABLE` VALUES('XYZ', b'0');

Answer 2

Since bit is a number not a string you need enter it like

INSERT INTO BITTESTTABLE values('XYZ',0)