Sql auto update dupdated_at

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

Sql auto update dupdated_at

CREATE TABLE t1 (
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

Source: stackoverflow.com

Similar codes

5 votes264 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
23 votes201 views1 answer
How remove column in mysql
SQL
4 votes191 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote149 views1 answer
Psql not found windows
SQL
0 vote196 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote230 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote187 views2 answers
Auto increment column in mysql query results
SQL
0 vote198 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote295 views1 answer
Print hello world in plsql
SQL
-1 vote182 views3 answers
Check table exist postgresql
SQL