多表查询内容ID的最大值

审核中 Mysql 未结已结置顶精帖

删除置顶取消置顶加精取消加精

 66  0

yswl VIP3 2023-08-25 10:00:52

悬赏：60金币编辑此贴

多表查询内容ID的最大值

SELECT MAX(id) FROM (
SELECT `id` FROM `dr_1_kejian`
UNION ALL
SELECT `id` FROM `dr_1_wend`
UNION ALL
SELECT `id` FROM `dr_1_zhuant`
UNION ALL
SELECT `id` FROM `dr_1_zttype`
) AS max_ids;