How to Set a Column with Default Value in MySQL with Alter Table Command

To add a default value to a column in MySQL, use the ALTER TABLE ... ALTER ... SET DEFAULT command:

--Example: Products have a default stock of 0
ALTER TABLE products ALTER COLUMN stocks integer SET DEFAULT 0;

--Example: Products are available by default (removed optional COLUMN keyword)
ALTER TABLE products ALTER available SET DEFAULT true;
database icon
SQL editing that just rocks
PopSQL and MySQL, better together