/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 vote333 views1 answer
Oracle lowercase
SQL
1 vote364 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote364 views1 answer
When mysql server would not work in xampp
SQL
0 vote299 views2 answers
Denormalization in sql
SQL
5 votes316 views1 answer
Mongodb vs
SQL
6 votes345 views2 answers
Mysql first day of month
SQL
0 vote390 views1 answer
Oracle list datafiles
SQL
0 vote373 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote368 views1 answer
Wordpress database query change url
SQL
0 vote362 views1 answer
Apache Derby: Create SQL Dump with data
SQL