/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 vote320 views1 answer
Find difference in dates sql
SQL
1 vote319 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
-1 vote300 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
13 votes314 views5 answers
Sql default
SQL
0 vote310 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote306 views1 answer
Write sql query to show the details start from digit
SQL
0 vote324 views1 answer
Sql pad left 0
SQL
0 vote321 views1 answer
Mysql readable output
SQL
2 votes327 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
10 votes310 views2 answers
Sql merge statement
SQL