An existing MySQL table has a DateTime field which is not null and having a Default Value set as '0001-00-00 00:00:00'. Is it possible to Alter this table to remove the default value for the DateTime field ?
1
-
I found this for you : stackoverflow.com/questions/11312433/…AchrafGounane– AchrafGounane2017-01-23 16:18:10 +00:00Commented Jan 23, 2017 at 16:18
Add a comment
|
3 Answers
Yes, you can drop the default using an ALTER TABLE statement like this:
alter table your_table
alter column your_column drop default;
Comments
To drop the default from multiple datetime columns in a table:
ALTER TABLE your_table
ALTER COLUMN columnname1 DROP DEFAULT,
ALTER COLUMN columnname2 DROP DEFAULT,
ALTER COLUMN columnname3 DROP DEFAULT,
....
Comments
You can simply change the column and exclude default clause using following query. Here T1 is table containing default value for column updated and subject. You can simply remove default value as given below:
ALTER TABLE `T1`
CHANGE `updated` `updated` DATETIME NOT NULL,
CHANGE `subject` `subject` VARCHAR(100)
