主要是创建表的时候在字段上面指定on update
一、创建测试表
drop table test_t1;
create table test_t1 (id int,name text, last_update_date timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
二、测试功能
insert into test_t1 (id ,name) values
(1,'1'),
(2,'1')
select * from test_t1;
update test_t1 set name = '2' where id = 2
三、完整代码
drop table test_t1;
create table test_t1 (id int,name text, last_update_date timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
insert into test_t1 (id ,name) values
(1,'1'),
(2,'1')
select * from test_t1;
update test_t1 set name = '2' where id = 2