/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

4 votes213 views1 answer
W3schools create table
SQL
1 vote230 views1 answer
Select from describe sql
SQL
0 vote219 views1 answer
Mysql show create db
SQL
-1 vote136 views2 answers
Datetime sql server week
SQL
0 vote185 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
-1 vote250 views1 answer
Partial search in sql
SQL
2 votes236 views2 answers
How to add not null constraint in sql
SQL
0 vote222 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote189 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote222 views1 answer
How much space does sql server take per row
SQL