/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 vote268 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote263 views1 answer
Postgresql regular expression special characters
SQL
0 vote306 views1 answer
Sql cursor example multiple columns
SQL
0 vote272 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote267 views1 answer
Get cpu details sql
SQL
0 vote287 views1 answer
Can we rollback in sql
SQL
0 vote262 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote275 views1 answer
Sql values not in another table
SQL
3 votes273 views2 answers
Oracle grants
SQL
0 vote272 views1 answer
Sql show all users
SQL