/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

3 votes226 views2 answers
Mysql time
SQL
0 vote233 views1 answer
Get null value in sql
SQL
0 vote253 views1 answer
How to check database engine in mysql
SQL
0 vote196 views1 answer
Mysqli or pdo
SQL
0 vote234 views1 answer
Mysql could not fetch tables
SQL
0 vote291 views1 answer
How to add auto increment primary key
SQL
0 vote250 views1 answer
Limit in access query
SQL
0 vote291 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote225 views1 answer
Postgres count string length
SQL
4 votes227 views3 answers
Count with where
SQL