/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

0 vote145 views1 answer
Oracle cpu metric
SQL
0 vote131 views3 answers
Postgresql grant alter table to user
SQL
0 vote144 views1 answer
Flexible search query delete table
SQL
0 vote145 views2 answers
Postgresql get long running queries
SQL
6 votes141 views2 answers
Join vs union
SQL
0 vote145 views2 answers
Oracle select
SQL
0 vote134 views1 answer
Mysql query single row
SQL
0 vote145 views1 answer
Mysql query to select the highest value
SQL
0 vote131 views1 answer
Mysql create table columns with spaces
SQL
0 vote142 views1 answer
Data types mysql vs postgresql
SQL