/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

10 votes227 views5 answers
Mysql create user
SQL
0 vote232 views4 answers
User defined function sql
SQL
7 votes219 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote232 views1 answer
WHERE not regex in SQL
SQL
1 vote208 views1 answer
Delete row mssql
SQL
0 vote212 views1 answer
Postgres full text search example
SQL
0 vote214 views2 answers
Sql regex vowel
SQL
0 vote212 views2 answers
Mysql disable foreign key checks
SQL
1 vote220 views1 answer
Mysql data from file
SQL
0 vote229 views1 answer
Show mysql account privilleges
SQL