/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 vote184 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote199 views1 answer
Sql constarint
SQL
1 vote173 views1 answer
Oracle explain plan
SQL
1 vote172 views1 answer
Sql oracle update multiple rows
SQL
17 votes213 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote177 views1 answer
Temp table vs variable table in sql server
SQL
9 votes176 views2 answers
Mysql change value
SQL
1 vote221 views2 answers
Install sql server management studio ubuntu
SQL
0 vote180 views1 answer
Csv to sqlite python
SQL
0 vote175 views1 answer
Sqlite closes value
SQL