/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

2 votes185 views1 answer
Mysql id of inserted row
SQL
0 vote228 views1 answer
Sqlite display data in separated columns
SQL
1 vote180 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote190 views4 answers
User defined function sql
SQL
0 vote170 views1 answer
Get cpu details sql
SQL
0 vote179 views1 answer
Search starting with mysql
SQL
3 votes162 views1 answer
Oracle limit user tablespace
SQL
0 vote180 views1 answer
Search mysql database for column
SQL
0 vote171 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
2 votes174 views2 answers
How to check data type in sql server
SQL