获取针对特定ID插入到sql中的最新行 - Getting the latest row inserted to the sql for a certain ID

Getting the latest row inserted to the sql for a certain ID

本文关键字：sql 最新插入 ID 获取 | 更新日期: 2023-09-27

我正在创建当前工资报告

这是我的查询:

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id";

，输出为:输出和向下滚动，这是输出的延续。

总而言之，查询显示某个ID的所有记录，但我希望它显示该ID在数据库中最后插入的数据。这是怎么发生的?

要获得最新的行，您必须按id desc排序，并且只能获得一个记录集limit 1。

所以代码是

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id ORDER BY employees.id DESC LIMIT 1 ";

try this

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id ORDER BY employees.id DESC  LIMIT 1 "

使用这个MySQL ORDER BY or LIMIT

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id ORDER BY employees.id DESC LIMIT 1";

$sql = "SELECT t1.*,t1.*
FROM payroll t1 join employees t2 on t1.id = t2.id
WHERE t1.username='$username' order by t2.id desc limit 1";