工作笔记day1：MySQL select if 查询最后一个主键 id

select if 的用法解释

案例

• 查询最后一个主键id

SELECT IF(MAX(id) IS NULL, 0, MAX(id)) AS maxid FROM users;

• 查询到要新增的id

SELECT IF(MAX(id) IS NULL, 0, (MAX(id) + 1)) AS newid FROM users;

• 查询最小的主键id

SELECT IF(MIN(id) IS NULL, 0, MIN(id)) AS minid FROM users;

• 查询最后一条插入的数据

SELECT * FROM users WHERE id = (
	SELECT IF(MAX(id) IS NULL, 0, MAX(id)) AS maxid FROM users
);