mysql alter table add column default value code example

Example 1: postgresql change column type

ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;

Example 2: mysql add column default value

ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;

Example 3: alter table delete column

ALTER TABLE "table_name" DROP "column_name";

Example 4: how to add default constraint in mysql

ALTER TABLE "name_table" ALTER "name_column" 
SET DEFAULT value_default;

Example 5: set default column value sql

Name Varchar(255) default "Fred"