mysql查询maxid取最新_从MAX(ID),MIN(ID)MYSQL查询获取更多信息？

这是一种使用UNION的方法：

SELECT column1, column2

FROM mytable

WHERE series = 'white' AND ID IN

(

SELECT MIN(ID) FROM mytable WHERE series = 'white'

UNION

SELECT MAX(ID) FROM mytable WHERE series = 'white'

)

为了获得良好的性能,请在(series,id)上添加组合索引.

或者可能具有更好性能的另一种变体：

(

SELECT column1, column2

FROM mytable

WHERE series = 'white'

ORDER BY ID

LIMIT 1

)

UNION

(

SELECT column1, column2

FROM mytable

WHERE series = 'white'

ORDER BY ID DESC

LIMIT 1

)

这也可以在(series,id)上使用组合索引.