/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 vote118 views1 answer
Into sql
SQL
2 votes115 views5 answers
Alter table primary key postgresql
SQL
0 vote160 views1 answer
Database get 10 user aleatory
SQL
0 vote225 views1 answer
Mysql readable output
SQL
0 vote229 views1 answer
Run docker container with database as rds metabase
SQL
0 vote161 views1 answer
Mysql local password denied
SQL
1 vote152 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote235 views1 answer
Trigger
SQL
1 vote161 views1 answer
Sql into vs insert into
SQL
0 vote154 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL