Completed

Ajustar query en Mysql 8 por incompatibilidad con sql_mode=only_full_group_by

Published on the June 12, 2019 in IT & Programming

About this project

Open

Tengo el siguiente Query que funciona en MySql 5 pero en versión Mysql 8 no funciona y me genera el error  incompatibilidad con sql_mode=only_full_group_by
el query es :
select distinct  id_param_asignaturas,asignaturas,id_relacion,`ap`.fk_id_param_asignaturas,`AP`.fk_id_param_programas,fk_escuela,programa, id_param_temas,temas
FROM `param_asignaturas` `A`
left join `asignatura_vs_programa` `ap`
on `ap`.`Fk_id_param_asignaturas` = `A`.`Id_param_asignaturas`
left join `param_programas` `p`
on `p`.`Id_param_programas` = `AP`.`Fk_id_param_programas`
inner join `param_temas` `t` on `t`.`Fk_id_param_asignaturas` = `A`.`Id_param_asignaturas`
WHERE `P`.`Fk_escuela` = 5
group by  `a`.`Id_param_asignaturas`
order by `p`.`programa` ASC;

Category IT & Programming
Subcategory Web development
What is the scope of the project? Small change or bug
Is this a project or a position? Project
I currently have I have specifications
Required availability As needed
Roles needed Developer

Delivery term: June 13, 2019

Skills needed

MySQL PHP

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!

Other projects posted by M. L.