Below is the command to add a boolean type column as default 0 to an existing table in mysql:
ALTER TABLE `YourTableName` ADD COLUMN `YourColumnName` BIT NOT NULL DEFAULT b'0'
Below is the command to add a boolean type column as default 0 to an existing table in mysql:
ALTER TABLE `YourTableName` ADD COLUMN `YourColumnName` BIT NOT NULL DEFAULT b'0'