/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 vote298 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote309 views1 answer
Drop database using terminal postgres
SQL
-1 vote326 views1 answer
Create view in mysql workbench
SQL
5 votes299 views4 answers
Change auto increment mysql
SQL
0 vote295 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote309 views1 answer
Kill slow queries mysql
SQL
3 votes298 views1 answer
Mysql set field unique
SQL
0 vote303 views1 answer
Less mysql display
SQL
28 votes260 views6 answers
Distinct sql
SQL
5 votes295 views1 answer
Postgres integer to serial
SQL