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

0 vote137 views1 answer
Get cpu details sql
SQL
2 votes83 views2 answers
Mysql get last character of string
SQL
1 vote124 views1 answer
How to test for sql injection
SQL
0 vote126 views1 answer
Sql join on a subquery
SQL
0 vote138 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote160 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
4 votes122 views3 answers
Sql drop database if exists
SQL
2 votes134 views2 answers
Create temporary table in mysql
SQL
1 vote120 views1 answer
How to between in sql
SQL
8 votes119 views1 answer
Alter tablespace add datafile
SQL