/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 vote184 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote198 views1 answer
Exit psql
SQL
0 vote207 views1 answer
Grant owner postgresql
SQL
58 votes551 views6 answers
Create new user in postgres
SQL
21 votes254 views3 answers
Average sql
SQL
0 vote184 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote195 views1 answer
Ansi sql count duplicate rows
SQL
1 vote312 views1 answer
Adding a check statement in sql
SQL
0 vote235 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
1 vote189 views2 answers
Sql server add time to date
SQL