/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 vote110 views1 answer
How to truncate a table in databse
SQL
-1 vote117 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote134 views1 answer
Mysql select random rows large table
SQL
-1 vote111 views1 answer
Export mysql table to file
SQL
0 vote124 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote109 views1 answer
2020 new year
SQL
0 vote118 views1 answer
Sql contains numeric characters
SQL
1 vote120 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote115 views1 answer
Sql developer search all packages for text
SQL
1 vote119 views1 answer
Sql in array query
SQL