By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.20 |
id | name | deleted_at |
---|---|---|
1 | Food | null |
2 | Stationery | null |
id | cate_id | vendor_id | name | deleted_at |
---|---|---|---|---|
1 | 1 | 1 | Bread | null |
2 | 1 | 2 | Milk | null |
5 | 2 | 2 | Pencil | null |
id | name | deleted_at |
---|---|---|
1 | Woolies | null |
2 | Cole | 2020-01-18 |
product_id | product_name | product_count |
---|---|---|
1 | Bread | 1 |
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_513414584.c.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_513414584.c.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
cate_id | cate_name | total_product |
---|---|---|
1 | Food | 0 |
2 | Stationery | 0 |
cate_id | cate_name | total_product |
---|---|---|
1 | Food | 1 |
2 | Stationery | 0 |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Category
--|----------|----------|
id|name |deleted_at|
--|----------|-----' at line 1