/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 votes209 views1 answer
How to check schema privileges in oracle
SQL
0 vote172 views1 answer
Query for maximum salary
SQL
0 vote213 views1 answer
Query only first letter string
SQL
1 vote202 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote208 views1 answer
How to select a row in sql
SQL
1 vote206 views1 answer
How to select rows with no matching entry in another table?
SQL
2 votes193 views1 answer
Ssh mysql port forwarding
SQL
0 vote250 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
7 votes222 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote209 views1 answer
Decalre temp table sql
SQL