/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 vote140 views1 answer
What is metadata in sql
SQL
0 vote145 views1 answer
Hour and minute between two datatime sql
SQL
1 vote158 views2 answers
One to one and one to many relationship
SQL
18 votes136 views3 answers
Find column name in database
SQL
9 votes136 views2 answers
Sql server check table exists
SQL
0 vote136 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote143 views1 answer
SQL: calculate hours from two dates
SQL
0 vote243 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
1 vote130 views1 answer
Oracle sql create view
SQL
0 vote133 views1 answer
Mysql does collate nopad recognize space
SQL