/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

27 votes228 views4 answers
Get all tables with column name sql
SQL
11 votes227 views3 answers
Change column name sql server management studio
SQL
0 vote229 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote241 views1 answer
Mariadb cast null to 0
SQL
1 vote251 views2 answers
Drop table with constraints
SQL
2 votes226 views1 answer
Tsql copy table
SQL
0 vote275 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
2 votes232 views6 answers
Mysql change timezone
SQL
1 vote215 views1 answer
SQL server query column yes or no
SQL
16 votes236 views3 answers
Tsql rename column name
SQL