php - 从 mysql 表中获取最后更新的值

Question

大家好，我是 mysql 开发的新手......我有一个表设置......我只需要在 mysql 中返回最后更新的值。

所以我对它进行了更多研究，并且找到了为此目的创建触发器的解决方案..

所以我的代码看起来像

 CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL AUTO_INCREMENT ,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),
   PRIMARY KEY (ID)
);

INSERT INTO  CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)  
VALUES (1,'aff',2,3,5),
 (2,'lolyeah',9,13,15);

触发器看起来像

CREATE TRIGGER getrandom 
AFTER UPDATE ON CUSTOMERS
FOR EACH ROW
BEGIN
UPDATE CUSTOMERS 
SET NAME = 'somerange'
WHERE ADDRESS = 3;
select NAME
END;

上面的触发器实际上并没有起作用..

我需要的是，当我更新 CUSTOMERS 列时，我需要返回最新的更新值。

希望你们能帮助我..谢谢

Answer 1

1. 创建一个带有 date_modified(日期)的列
2. 输入添加或更新新客户的日期
3. 从 Date_modified 的客户订单中选择 *

代码{

数据库:

 CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL AUTO_INCREMENT ,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),
   Date_Modified date,
   PRIMARY KEY (ID)
);

INSERT INTO  CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY,Date_Modified)  
VALUES (1,'aff',2,3,5,'2012-11-10'),
 (2,'lolyeah',9,13,15,'2014-11-10');

SELECT * FROM CUSTOMERS ORDER BY Date_Modified ASC LIMIT 1;

sql 没有 id:

 CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL AUTO_INCREMENT ,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),
   Date_Modified date,
   PRIMARY KEY (ID)
);

INSERT INTO  CUSTOMERS (,NAME,AGE,ADDRESS,SALARY,Date_Modified)  
VALUES ('aff',2,3,5,'2012-11-10'),
 ('lolyeah',9,13,15,'2014-11-10');

SELECT * FROM CUSTOMERS ORDER BY Date_Modified ASC LIMIT 1;