/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

1 vote104 views1 answer
Update mysql centos
SQL
0 vote112 views1 answer
How to order result of subquery in select
SQL
0 vote121 views1 answer
Less than date query sqlachemy
SQL
0 vote126 views1 answer
Grant owner postgresql
SQL
2 votes126 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
1 vote118 views2 answers
Pl sql case
SQL
0 vote109 views1 answer
Psql check if value in array
SQL
1 vote113 views1 answer
Show table columns
SQL
0 vote131 views1 answer
Arithmetic expression in sql
SQL
0 vote116 views1 answer
Grant privileges of databse to user
SQL