Microsoft SQL Server 数据库查询记录

Microsoft SQL Server 数据库查询记录

对于自己不熟悉的语言 加上不熟悉的系统,搞懂个别地方的业务逻辑,查询数据库的查询记录就成了一种简便的方法,这里就是工作中遇到的问题,在此记录一下,方便自己,方便大家

MySQL Group By 出错

MySQL Group By 出错

MySQL Group By 查询出错 (1055): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rbac_auth_assignment.item_name' which is not functionally depe