/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

5 votes370 views1 answer
Oracle sysdate - 1 month
SQL
0 vote367 views4 answers
Postgresql between month
SQL
3 votes407 views2 answers
Synonym oracle
SQL
1 vote378 views1 answer
Mysql strict_trans_tables
SQL
0 vote407 views1 answer
How to locate pg_hba.conf file
SQL
0 vote370 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
1 vote336 views2 answers
Sql where is not number
SQL
0 vote343 views1 answer
What is the essence of SQL?
SQL
12 votes365 views4 answers
Import mysql database command line linux
SQL
0 vote378 views1 answer
Count number of entires by months sql
SQL