/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 vote303 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote296 views1 answer
Regular expression in sql server
SQL
0 vote314 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote265 views1 answer
Drop check command
SQL
0 vote305 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote269 views1 answer
Difference between cross apply and inner join
SQL
0 vote274 views1 answer
Oracle enable chain
SQL
0 vote287 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
4 votes285 views1 answer
Describe table mysql
SQL
0 vote288 views1 answer
Sql server datetime to string
SQL