/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

11 votes266 views6 answers
Mysql else if
SQL
0 vote239 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote243 views1 answer
Sql dmv to capture updates
SQL
0 vote231 views1 answer
Sql delete where x or y or z
SQL
0 vote277 views1 answer
Sql show founctions
SQL
3 votes221 views1 answer
Oracle undo tablespace list by user
SQL
0 vote250 views1 answer
Oracle lower in where clause
SQL
11 votes223 views2 answers
Having clause
SQL
0 vote221 views1 answer
Bash block size ls /var/lib/mysql
SQL
1 vote258 views1 answer
Trim leading zeros in sql
SQL