/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 vote347 views1 answer
Execut sql python
SQL
2 votes335 views2 answers
Set database timezone mysql
SQL
1 vote340 views1 answer
Mysql current running queries
SQL
3 votes327 views1 answer
Oracle user quota unlimited
SQL
0 vote410 views2 answers
Remove mysql workbench ubuntu
SQL
4 votes343 views2 answers
What is table in sql
SQL
2 votes338 views1 answer
Sql server find table name
SQL
5 votes344 views2 answers
Add column postgres with default value
SQL
1 vote354 views1 answer
Mariadb case switch
SQL
4 votes343 views3 answers
Postgres set default value
SQL