Do menus have children in MySQL?

S

sitev_ru2015-09-30 12:30:21

MySQL

sitev_ru, 2015-09-30 12:30:21

The menu table contains the fields: name, url, parent (name, where to go and the parent menu item) ...
How to determine that the item contains child elements?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

Dmitry Kovalsky, 2015-09-30
@sitev_ru

You can make JOIN type
and check that child.name IS NOT NULL
For example

Similar questions

S

sergeevpetro2015-07-23 14:55:36

How to create a post request using Awesomium C#? 2Reply

V

Vladimir2017-07-04 13:29:51

How to prevent a route change on $routeChangeStart so that $routeChangeError will work after? 2Reply

N

Nikolai Steshenko2021-05-24 00:59:15

How to add a field to registration or remove instantaCms? 2Reply

K

Kirill Morozov2017-07-17 18:31:57

How to rewrite code that works in Python 2.7 so that it works in version 3.6? 2Reply

V

Vadim Belkin2015-09-04 10:09:02

What are the advantages of switching the view of the product catalog with a page reload (different layout for each view)? 4Reply

Didn't find what you were looking for?

Ask your question