mysql5.7版本以上对group by 分组有了新需求,要求group by 后的字段要与select后查询的字段一致,否则就会报错,报错信息如下:
The Product table has 700K records in it.The query: SELECT TOP 1 ID, Name FROMProduct WHERE contains(Name, \'\"White Dress\"\')