mysql 查询语句中*必须放在第一位吗?

Question

我做了一个测试
下面是通过的

SELECT *,MIN(id), COUNT(openid) AS c FROM user GROUP BY `openid` HAVING c >1

下面的写法就会报错

SELECT MIN(id),*, COUNT(openid) AS c FROM user GROUP BY `openid` HAVING c >1

sql里是有这个规定吗

Answer 1

如果不是在首位, 需要通过表名引用, 这也是在多表联合查询时, 需要查某个表全部字段的常用做法.

如:

SELECT max(id), user.* FROM user;

或

SELECT max(id), t.* FROM user t;

Answer 2

*是所有项。模糊匹配的