Mysql
wb736
继续成长
展开
-
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
MYSQL 执行 select max(c_id),u_ano,u_bno,c_text from chat A group by concat((if(A.u_ano<A.u_bno,A.u_ano,A.u_bno)),(if(A.u_ano>A.u_bno,A.u_bno,A.u_ano,A.u_bno))); 遇到的问题: ERROR 1055 (42000): ...原创 2018-03-12 15:01:53 · 797 阅读 · 0 评论 -
MYSQL ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
这可能是MySQL在InnoDB中设置了foreign key关联,造成无法更新或删除数据。可以通过设置FOREIGN_KEY_CHECKS变量来避免这种情况。 SET FOREIGN_KEY_CHECKS = 0; 删除完成后设置 SET FOREIGN_KEY_CHECKS = 1; MYSQL: Cannot delete or update a parent ro...原创 2018-04-03 16:20:48 · 4769 阅读 · 0 评论