/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 vote284 views1 answer
Sqlalchemy get ids
SQL
0 vote371 views1 answer
Mysql show schema
SQL
0 vote320 views1 answer
Date 3 months from today sql
SQL
1 vote274 views1 answer
Sql select where id not exists in another table
SQL
0 vote293 views1 answer
Difference between min and max date sql
SQL
0 vote303 views1 answer
Call object contructor and call methods of object
SQL
7 votes307 views3 answers
Postgresql dump and restore db
SQL
0 vote294 views1 answer
Database db connection string format
SQL
0 vote296 views1 answer
WHERE not regex in SQL
SQL
1 vote290 views1 answer
Sql dcl
SQL