„MySql Issue - Json” változatai közötti eltérés
Ugrás a navigációhoz
Ugrás a kereséshez
(Új oldal, tartalma: „ ''Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c1_dev01.workings.id' which is not functionally dependent on columns in GRO…”) |
a |
||
| 4. sor: | 4. sor: | ||
<br><br> | <br><br> | ||
'''MySQL server-en Root módban'''<br> | '''MySQL server-en Root módban'''<br> | ||
| − | SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); | + | * SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); |
| + | Vagy:<br> | ||
| + | * ''PHP MyAdmin'' (root) -> Localhost -> Variables (Változók) -> sql mode | ||
<br><br><br> | <br><br><br> | ||
https://stackoverflow.com/questions/23921117/disable-only-full-group-by | https://stackoverflow.com/questions/23921117/disable-only-full-group-by | ||
[[Fájl:5CQdo.png|bélyegkép|jobbra|delet only_full_group_by]] | [[Fájl:5CQdo.png|bélyegkép|jobbra|delet only_full_group_by]] | ||
A lap 2020. március 21., 08:00-kori változata
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c1_dev01.workings.id' which is not functionally dependent on columns in GROUP BY clause;
Incompatible with sql_mode=only_full_group_by Syntax error or access violation: 1055 Expression.
MySQL server-en Root módban
- SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',));
Vagy:
- PHP MyAdmin (root) -> Localhost -> Variables (Változók) -> sql mode
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
