mysql select column_mysql select后边的column不在group by里会怎样

mysql 5.7 的manual：

http://dev.mysql.com/doc/refman/5.7/en/counting-rows.html

4.3.4.8 Counting Rows

If

ONLY_FULL_GROUP_BY

is not enabled, the query is processed by treating all rows as a single group, but the value selected for each named column is indeterminate. The server is free to select the value from any row:

mysql>

+--------+----------+

| owner | COUNT(*) |

+--------+----------+

| Benny | 2 |

| Diane | 2 |

| Gwen | 3 |

| Harold | 2 |

+--------+----------+SELECT owner, COUNT(*) FROM pet GROUP BY owner;

mysql>

Query OK, 0 rows affected (0.00 sec)

mysql>

+--------+----------+

| owner | COUNT(*) |

+--------+----------+

| Harold | 8 |

+--------+----------+

1 row in set (0.00 sec)SET sql_mode = '';SELECT owner, COUNT(*) FROM pet; 但是我们的mysql 供应商提供的中间件不支持这个写法，表分片后owner会返回null....