Answers for "mysql alter column change default default null on update current_timestamp(6)"

mysql update column default value CURRENT_TIMESTAMP error

# Best case you can do is drop the column and recreate it with the set timestamp;
ALTER TABLE `TABLE_NAME` DROP COLUMN `COLUMN_NAME`;
ALTER TABLE `TABLE_NAME` ADD COLUMN `COLUMN_NAME` TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

Posted by: Guest on October-26-2021

Code answers related to "mysql alter column change default default null on update current_timestamp(6)"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql alter column change default default null on update current_timestamp(6)"

Code answers related to "mysql alter column change default default null on update current_timestamp(6)"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql alter column change default default null on update current_timestamp(6)"

Code answers related to "mysql alter column change default default null on update current_timestamp(6)"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us