/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 vote185 views1 answer
Exectuer myssql .sql
SQL
0 vote192 views1 answer
Drop index in sql
SQL
6 votes201 views2 answers
Insert into select mysql
SQL
0 vote166 views1 answer
Vbscript create ADODB.Connection
SQL
2 votes168 views1 answer
How to find constraints on a table in oracle
SQL
5 votes260 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
2 votes131 views1 answer
Sql float to int
SQL
0 vote175 views1 answer
Sql developer connect to sql server
SQL
1 vote167 views1 answer
Psql filed name alter
SQL
0 vote178 views1 answer
Soql queries for not contact related account records in salesforce
SQL