/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

1 vote342 views1 answer
Round function in sql oracle
SQL
9 votes309 views3 answers
Where in sql
SQL
1 vote352 views1 answer
Mysql previous year
SQL
1 vote326 views1 answer
How to group by month using sql server
SQL
0 vote322 views1 answer
Placements hackerrank solution
SQL
0 vote328 views1 answer
Search column name sql
SQL
0 vote314 views3 answers
Drop multiple columns in sql
SQL
11 votes350 views2 answers
Mysql disable safe mode
SQL
1 vote365 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
9 votes329 views5 answers
Sql limit
SQL