Skip to content
Studyraft
Menu
  • About
  • Contact Us
  • Privacy Policy

mysql add column boolean default 0

Aug 29 2022December 9, 2022

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'

Related Posts:

  • MySQL alter column data type
  • Check column data type in mysql
  • mysql add column boolean default 1
  • Add boolean column existing table mysql
  • mysql add column boolean default false
Aug 29 2022December 9, 2022

© 2025 Studyraft