/SQL/Mysql sql add created updated timestamp to existing table

Mysql sql add created updated timestamp to existing table

ALTER TABLE t1
ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

Source: stackoverflow.com

Similar codes

0 vote168 views1 answer
Sql select most frequent value in group
SQL
6 votes167 views5 answers
Get current date sql
SQL
10 votes181 views1 answer
Oracle dependencies table
SQL
3 votes197 views1 answer
Sql add two values together
SQL
0 vote144 views1 answer
Check id exist or not in sql
SQL
0 vote184 views1 answer
Tsql cmd exec script from file
SQL
0 vote173 views1 answer
R2dbc-postgresqldriver dependency
SQL
1 vote196 views3 answers
Update from select sqlite
SQL
4 votes178 views3 answers
Drop Table Oracle
SQL
0 vote164 views1 answer
Mod function example
SQL