/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

1 vote203 views1 answer
Oracle finding duplicate records
SQL
0 vote202 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
1 vote198 views2 answers
Postgresql backup and restore globals and data
SQL
1 vote213 views3 answers
Reset sql primary key
SQL
0 vote191 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
6 votes237 views2 answers
Install psql mac
SQL
10 votes201 views5 answers
Between keyword in sql
SQL
0 vote212 views1 answer
Like date sql server not working
SQL
5 votes214 views4 answers
Mysql update column with value from another table
SQL
0 vote202 views2 answers
Create new table plsql
SQL