/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 vote326 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote339 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote325 views1 answer
Insert array into mysql column
SQL
1 vote337 views1 answer
Get table column names sql ssms
SQL
1 vote295 views1 answer
Unique vs distinct sql
SQL
0 vote325 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
2 votes320 views1 answer
Mysql find tables with name
SQL
0 vote331 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote279 views1 answer
How to check oracle index table
SQL
10 votes355 views2 answers
Mysql drop database if exists
SQL