„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…”) |
|||
| (3 közbenső módosítás, amit egy másik szerkesztő végzett, nincs mutatva) | |||
| 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','')); |
| − | <br>< | + | Vagy:<br> |
| + | * ''PHP MyAdmin'' (root) -> Localhost -> Variables (Változók) -> sql mode | ||
| + | |||
| + | ==== megjegyzés ==== | ||
| + | /etc/mysql/my.cnf v. /etc/my.cnf | ||
| + | |||
| + | <code> | ||
| + | [mysqld] | ||
| + | |||
| + | sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" | ||
| + | </code> | ||
| + | |||
| + | [[Fájl:5CQdo.png|bélyegkép|jobbra|delete only_full_group_by]] | ||
| + | |||
| + | ==Forrás== | ||
https://stackoverflow.com/questions/23921117/disable-only-full-group-by | https://stackoverflow.com/questions/23921117/disable-only-full-group-by | ||
| − | |||
| − | |||
A lap jelenlegi, 2020. október 29., 16:07-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
megjegyzés
/etc/mysql/my.cnf v. /etc/my.cnf
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Forrás
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
