/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

8 votes264 views1 answer
Mysql dump restore
SQL
0 vote218 views1 answer
Mysql url data type
SQL
0 vote201 views1 answer
How to get inserted id in sql server
SQL
0 vote196 views1 answer
Sql datediff db2
SQL
6 votes216 views4 answers
Mysql update set
SQL
11 votes253 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
1 vote214 views1 answer
SQL date part only of datetime
SQL
1 vote185 views4 answers
Sql now
SQL
0 vote199 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
2 votes184 views1 answer
Mysql auto increment jumping
SQL