mysql 查最小值或查最小值的id

查最小值简单，

select min(price) from shop where ok=1

如果查小最值对应的id编号或对应字段值是这样的

SELECT id FROM shop WHERE price IN (SELECT MIN(price) FROM shop WHERE ok=1)