/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 vote190 views1 answer
Hotw to alter lengh character vayng postgres
SQL
-1 vote168 views1 answer
How to use update trigger in sql
SQL
0 vote215 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote171 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote179 views1 answer
How to print mysql query of codeigniter query builder
SQL
18 votes186 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote173 views2 answers
Create row number in sql
SQL
1 vote214 views3 answers
Default password of mysql
SQL
0 vote180 views1 answer
Soql update query
SQL
0 vote247 views1 answer
Consulta alias con inner join
SQL