/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

21 votes213 views1 answer
SQL cheat sheet pdf
SQL
0 vote193 views1 answer
Mysql root localhost run
SQL
0 vote224 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
3 votes211 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote198 views1 answer
Sql query to force the database to be drop
SQL
0 vote171 views1 answer
Month mysql
SQL
1 vote272 views1 answer
Mysql get max value and id
SQL
1 vote206 views1 answer
Wherein mysql
SQL
0 vote200 views1 answer
Select last 2 characters sql
SQL
0 vote183 views1 answer
Oracle exchange subpartition
SQL