/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 vote173 views1 answer
Sql include rows with 0 values
SQL
0 vote180 views1 answer
TSQL convert csv to table
SQL
0 vote210 views1 answer
Mysql select row with min date
SQL
5 votes159 views1 answer
Oracle scan source ddl
SQL
1 vote135 views1 answer
Unique vs distinct sql
SQL
5 votes181 views3 answers
Day of week postgresql
SQL
0 vote165 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote173 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
3 votes163 views1 answer
Oracle APEX elapsed time
SQL
2 votes168 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL