/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

4 votes139 views2 answers
Error loading MySQLdb module.
SQL
3 votes170 views2 answers
Update part of a string in mysql
SQL
0 vote141 views1 answer
Get cpu details sql
SQL
0 vote122 views1 answer
Export partttion and import in oracle
SQL
1 vote144 views1 answer
Query for all indexes in table postgres
SQL
0 vote123 views1 answer
Call scalar valued function sql
SQL
3 votes131 views3 answers
Mysql select table names
SQL
92 votes350 views6 answers
Substring
SQL
0 vote129 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote134 views1 answer
Sql select by content lenght
SQL