我有一个表,其中一列被排序。MySQL会以某种方式检查它是否已排序吗?如果我在对col1进行排序的地方进行这样的查询SELECT from tab WHERE col1>890 AND col1<74893798,它是否与SELECT from tab WHERE id为了清楚起见,我们对col1进行了排序,因为它是从另一个按列排序的表中插入的。
我想了解在启用ONLY_FULL_GROUP_BY时查询是如何工作的。$query = "SELECT id, member_id, name, code, MIN(price) AS price, FROM tbl_product GROUP BY code";$query = "SELECT *, MIN(price) AS price FROM tbl_product GROUP BY code";