/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 vote141 views1 answer
Get date from timestamp in mysql
SQL
0 vote126 views1 answer
Check connections to database postgres
SQL
0 vote139 views1 answer
Mysql terminal run sql file
SQL
0 vote141 views2 answers
Close external port 3306 with iptables
SQL
2 votes156 views3 answers
Postgres json to string
SQL
3 votes137 views3 answers
Postgresql random number
SQL
42 votes204 views6 answers
Install beautifulsoup
SQL
2 votes135 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote144 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote271 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL