(SELECT * from test1 order by test1.int desc LIMIT 1) union all (SELECT * FROM test2 order by test2.int desc LIMIT 1)
取test1和test2中最后一条数据。适合只展示一条数据的列表首页。仅供参考
(SELECT * from test1 order by test1.int desc LIMIT 1) union all (SELECT * FROM test2 order by test2.int desc LIMIT 1)
取test1和test2中最后一条数据。适合只展示一条数据的列表首页。仅供参考