选择列表；这与我的 sql 中的 DISTINCT 不兼容

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllEventIdList_SP`(in skillId varchar(50),in offsetvalue int,in recordlimit int,out totalcountquery text)
BEGIN

 set @whereClause="   ";

 SET @skills=concat('"',skillId,'"');

 if(skillId is not null and skillId <>"" and skillId <>0) then
 set @whereClause=concat(@whereClause," where skill_id in (",@skills ,")");

 end if;
     set totalcountquery=concat("select count(distinct (eventId)) from EventAttachmentList_View ",@whereClause);

  if(offsetvalue<recordlimit) then  
     set @SqlQuery=concat("select distinct (eventId),scheduleId from EventAttachmentList_View ",@whereClause,  " order by scheduleDate desc ", " limit " ,recordlimit , " offset 0");
     PREPARE querystatement FROM @SqlQuery;
     EXECUTE querystatement;
     DEALLOCATE PREPARE querystatement;

  else 

     set @SqlQuery=concat("select distinct (eventId),scheduleId from EventAttachmentList_View ",@whereClause,  " order by scheduleDate desc  ",  " limit " ,recordlimit , " offset ", offsetvalue);

     PREPARE querystatement FROM @SqlQuery;
     EXECUTE querystatement;
     DEALLOCATE PREPARE querystatement;

 end if;


END

这是我调用数据时的动态查询 tju.GetAllEventIdList_SP('1',17, 16, @totalcountquery); 然后我收到错误 ORDER BY 子句的表达式 #1 不在 SELECT 列表中，引用的列“EventAttachmentList_View.scheduleDate”不在 SELECT 列表中；这与 DISTINCT 不兼容

请建议我如何解决此问题，查询中需要进行哪些更改

您的 MySQL 版本是ONLY_FULL_GROUP_BY模式启用这意味着（在 MySQL 5.7.5 及更高版本中）任何查询使用DISTINCT and ORDER BY将需要以下列ORDER BY也能在SELECT查询的一部分。

修复方法是添加scheduleDate to the SELECT您的部分查询如下所示：

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllEventIdList_SP`(in skillId varchar(50),in offsetvalue int,in recordlimit int,out totalcountquery text)
BEGIN

 set @whereClause="   ";

 SET @skills=concat('"',skillId,'"');

 if(skillId is not null and skillId <>"" and skillId <>0) then
 set @whereClause=concat(@whereClause," where skill_id in (",@skills ,")");

 end if;
     set totalcountquery=concat("select count(distinct (eventId)) from EventAttachmentList_View ",@whereClause);

  if(offsetvalue<recordlimit) then
     set @SqlQuery=concat("select distinct (eventId),scheduleId,scheduleDate from EventAttachmentList_View ",@whereClause,  " order by scheduleDate desc ", " limit " ,recordlimit , " offset 0");
     PREPARE querystatement FROM @SqlQuery;
     EXECUTE querystatement;
     DEALLOCATE PREPARE querystatement;

  else

     set @SqlQuery=concat("select distinct (eventId),scheduleId,scheduleDate from EventAttachmentList_View ",@whereClause,  " order by scheduleDate desc  ",  " limit " ,recordlimit , " offset ", offsetvalue);

     PREPARE querystatement FROM @SqlQuery;
     EXECUTE querystatement;
     DEALLOCATE PREPARE querystatement;

 end if;


END