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 vote143 views1 answer
Mssql dockere
SQL
40 votes196 views6 answers
Update table mysql
SQL
1 vote130 views1 answer
Pl sql create table from another table
SQL
0 vote140 views2 answers
Sql searching via key word
SQL
11 votes191 views3 answers
Pl sql example
SQL
1 vote129 views1 answer
GROUP BY clause; this is incompati
SQL
19 votes130 views5 answers
Date between in mysql
SQL
0 vote133 views1 answer
Sql pad left 0
SQL
0 vote161 views1 answer
Select top values sql
SQL
0 vote144 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL