/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 vote177 views1 answer
Convert LDAP Epoch to Date
SQL
1 vote172 views1 answer
T-sql disable system versioning
SQL
0 vote137 views1 answer
How to connect postgresql database with java
SQL
0 vote143 views1 answer
Greater than or equal to symbol in postgres
SQL
1 vote169 views2 answers
End mysql command
SQL
0 vote178 views1 answer
Mysql best varchar length size
SQL
0 vote151 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote155 views1 answer
Oracle table free space
SQL
2 votes144 views1 answer
Pandas to sql index
SQL
0 vote192 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL