/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

1 vote85 views1 answer
Mysql collation
SQL
1 vote129 views1 answer
Mysql text to decimal
SQL
0 vote128 views1 answer
Mysql default timestamp value to be current timestamp
SQL
2 votes123 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote136 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote180 views1 answer
Mysql grant access to one database
SQL
11 votes119 views1 answer
Oracle insert into where
SQL
-1 vote140 views1 answer
Phinehas Psalm 106
SQL
1 vote89 views1 answer
Ms sql how to see active job current run time
SQL
0 vote122 views1 answer
Cast for print sql
SQL