/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 vote200 views1 answer
Show create table in postgresql
SQL
7 votes200 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote215 views1 answer
Alter table add check constraint oracle
SQL
36 votes317 views6 answers
Change column data type sql
SQL
0 vote229 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote196 views1 answer
Grepper sql workbench download
SQL
3 votes239 views1 answer
Set default today mysql
SQL
0 vote199 views1 answer
Mysql with
SQL
0 vote201 views1 answer
Mysql 1 hour ago
SQL
0 vote271 views1 answer
Postgresql create table default value timestamp
SQL