/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 vote255 views1 answer
Show size of all tables postgres
SQL
0 vote332 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote277 views1 answer
Savepoint mysql script
SQL
0 vote271 views1 answer
On delete set default
SQL
11 votes255 views3 answers
Change column name sql server management studio
SQL
0 vote246 views1 answer
Login phpmyadmin without password
SQL
0 vote249 views1 answer
How to check even or odd in sql
SQL
0 vote286 views1 answer
Primary key start from number
SQL
0 vote263 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote246 views1 answer
Hibernate with springboot mysql
SQL