/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 vote104 views1 answer
Cannot pip install mysqlclient
SQL
4 votes105 views4 answers
Date less than in sql
SQL
0 vote115 views1 answer
What is default mysql database password in linux
SQL
19 votes106 views6 answers
Sql drop table if exists
SQL
2 votes146 views1 answer
Creating a view SQL
SQL
0 vote103 views1 answer
Sql replace id with name from another table
SQL
1 vote106 views1 answer
Oracle lowercase
SQL
0 vote129 views1 answer
Find how many tables in database sql query
SQL
1 vote111 views2 answers
Test sqlsrv connection
SQL
0 vote107 views1 answer
Get primary key of table
SQL