更新后获取以前的值-MySql [英] Get previous value after update - MySql

问题描述

我有一个包含ID和名称的表

I have a table which includes id and name

---    -----  
id     name
---    -----
1      pete

我的情况如下

$sql = "SELECT name FROM table_name WHERE id=1";

previous name - ''
current name - pete

现在我要更新

$sql = "UPDATE table_name SET name='dave' WHERE id=1";

previous name - pete
updated name - dave

$sql = "UPDATE table_name SET name='Alan' WHERE id=1";

previous name - dave
updated name - Alan

因此，在更新此表之后，我想获取其中存在的以前的记录.在我的示例中，我应该获得以前的名字以及更新的名字.如何做到这一点

So after i update this table, i wanted to fetch previous record which was present in it. In my example i should get previous name as well as updated name. How to achieve this

推荐答案

您可以通过在尽管，我看到您将帖子标记为php，我想您想在php中获取旧值，并且要执行此操作，您必须在UPDATE之前执行SELECT才能获得旧名称，以及在UPDATE之后的另一个SELECT以获取新名称.

Although, i see that you tagged your post as php and I guess you want to get the old value in php, and to do this, you have to do a SELECT before the UPDATE to get the old name, and another SELECT after the UPDATE to get the new name.

这篇关于更新后获取以前的值-MySql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！