/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

3 votes307 views1 answer
System.debug apex
SQL
1 vote344 views2 answers
Mysql between
SQL
0 vote358 views1 answer
Oracle table privileges
SQL
0 vote348 views1 answer
Not equal to blank in mysql
SQL
0 vote359 views1 answer
Mysql zerofill
SQL
0 vote338 views1 answer
Select last N rows mysql
SQL
0 vote349 views1 answer
Transaction database with php
SQL
0 vote363 views1 answer
Sql get year from datetime field
SQL
0 vote300 views2 answers
Spring properties file for db
SQL
44 votes392 views6 answers
Rename command in sql
SQL