/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 vote80 views1 answer
Kannst du deine finger trainieren
SQL
1 vote176 views1 answer
Oracle transaction rollback not working
SQL
0 vote122 views1 answer
Min and max salary and name in sql
SQL
0 vote123 views1 answer
Mysql select all where count more than"
SQL
0 vote122 views1 answer
Changer un mot de passe mysql
SQL
1 vote130 views1 answer
Sql server list locks
SQL
11 votes200 views1 answer
Oracle insert from select
SQL
3 votes128 views2 answers
Truncate table
SQL
17 votes119 views4 answers
Show tables sql server
SQL
0 vote121 views1 answer
Sql convert datetime to year
SQL