( ! ) Warning: PDOStatement::execute(): SQLSTATE[HY000]: General error: 3065 Expression #2 of ORDER BY clause is not in SELECT list, references column 'clicshopping_test_ui.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT in /home/www//boutique/in...
前言记录一个最近遇到的Mysql 问题。问题描述:在本地项目中,部分SQL 语句执行起来,总是会报一个错。而同样的SQL,在线上的服务器中执行起来没有任何问题。 (0)踩踩(0) 所需:1积分 NOSQL-redis-运维-单机安装 2024-10-18 20:33:24 积分:1 华为暑期实习面试 通用软件开发 ...
( ! ) Warning: PDOStatement::execute(): SQLSTATE[HY000]: General error: 3065 Expression #2 of ORDER BY clause is not in SELECT list, references column 'clicshopping_test_ui.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT in /home/www//boutique/in...