How to get category entries along with category subcategory entries via relations?

M

M

Melodic2014-08-29 21:33:50

MySQL

Melodic, 2014-08-29 21:33:50

How to get category entries along with category subcategory entries via relations?

Is Category(id,name,parentCategoryId)
Is Object(id,name)
Object and category are related MANY_MANY.
How to get category objects including subcategory objects?
For example, if the id of the root category is specified, then select ALL objects.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Maxim Grechushnikov, 2014-09-02
@maxyc_webber

use nested sets

Similar questions

L

Lecturer2020-09-26 22:38:29

How to display search results for sections in wordpress? 5Reply

F

fara_ib2019-09-21 18:21:15

How to set up adding a port to vlan after checking for 802.1x? 2Reply

G

GhostMath2022-02-09 15:51:25

How to solve the problem of non-synchronous clock frequency on hydraulic motors? 4Reply

F

Flanker3812015-05-28 16:54:35

Debian netstat output. What do the lines mean? 6Reply

K

Kratko632020-10-15 12:48:58

How to make a MySQL SELECT query from 2 tables based on multiple values? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question