Answers for "default value mysql"

mysql add column default value

ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;

Posted by: Guest on May-17-2020

mysql modify default value

ALTER TABLE tbl_name ALTER column_name SET DEFAULT new_value;

Posted by: Guest on July-20-2021

how to add default constraint in mysql

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

Posted by: Guest on August-07-2020

mysql default value

CREATE TABLE table_name(
   column_name data_type,
   Column_name data_type DEFAULT ‘value’
);

Posted by: Guest on April-15-2020

Code answers related to "default value mysql"