MYSQL

original: Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'railway.commission.commi_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by how can i config my mysql ??
5 Replies
Percy
Percy13mo ago
Project ID: 5cd8fd4a-5934-4c10-874d-f3003dfcb2c8
CREATIVESTAR
CREATIVESTAR13mo ago
5cd8fd4a-5934-4c10-874d-f3003dfcb2c8
Brody
Brody13mo ago
where are you getting this error?
CREATIVESTAR
CREATIVESTAR13mo ago
I wrote one query where I'm grouping the data it working fine in offline MySQL but when i deploy into railway and testing it's showing above error. @Brody how can we config MySQL in railway??
Brody
Brody13mo ago
show me a screenshot of your railway project