/SQL/Mysql update column default value CURRENT_TIMESTAMP error

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;

Similar codes

10 votes146 views2 answers
Sql rtrim
SQL
0 vote133 views1 answer
Date diff sql
SQL
0 vote152 views1 answer
Select into table variable
SQL
0 vote145 views1 answer
Mysql create table like
SQL
1 vote137 views1 answer
Create sample data postgresql
SQL
0 vote147 views1 answer
Create domain sql
SQL
32 votes149 views6 answers
Sql count where
SQL
5 votes147 views1 answer
Oracle get foreign keys on table
SQL
2 votes156 views1 answer
Power query concatenate
SQL
2 votes137 views1 answer
While loop sql
SQL