/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

-2 votes320 views1 answer
Trunc in sql
SQL
0 vote276 views1 answer
Create dabase postgresql
SQL
3 votes301 views2 answers
Sql random integer
SQL
0 vote328 views1 answer
Running mysql from bash sc
SQL
2 votes299 views1 answer
Oracle index size calculation
SQL
1 vote325 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote251 views2 answers
Denormalization in sql
SQL
0 vote304 views1 answer
Postgresql default value boolean
SQL
2 votes307 views4 answers
Mysql select into new table
SQL
4 votes339 views2 answers
Sqlalchemy_database_uri for mysql
SQL