I’ll give an example of specifying or changing the default value in the MySQL column.
Let’s see the list of tables in the database:
SHOW TABLES;
Let’s see the structure of the table we are interested in:
DESCRIBE internet_main;
Let’s say the activate column has the type date and the default value is 0000-00-00, and we want to make 3000-01-01, then we will execute sql query:
ALTER TABLE internet_main ALTER activate SET DEFAULT '3000-01-01';
You can also delete the default value:
ALTER TABLE internet_main ALTER activate DROP DEFAULT;
Or return it as it was:
ALTER TABLE internet_main ALTER activate SET DEFAULT '0000-00-00';
In strict mode MySQL can not set the value 0000-00-00, so you can temporarily disable the strict mode:
SET sql_mode = '';