Get category level in parent child table

Asked Aug 13 '22 at 10:44

Active Aug 21 '22 at 20:41

Viewed 121 times

I have category table which have category in parent and child relation

For example,

| cat_id   | cat_parent_id  |cat_name|
| -------- | -------------- |---------
| 1        |                |Car
| 2        | 1              |Porsche
| 3        | 2              |911
| 4        | 3              |Petrol, SUV >
| 5        | 4              |3.6L >
| 6        | 5              |3606CC H6 GAS SOHC Naturally Aspirated >
| 7        | 6              |2020
| 8        | 6              |2021
| 9        | 6              |2022

I need to get all category level from this table.

The need scenario is like this:

edited Aug 21 '22 at 20:41

Paul T.

4,703
11
25
29

asked Aug 13 '22 at 10:44

Vishal Patel

Which MySQL version as MySQL 8 makes it more easy – Raymond Nijland Aug 13 '22 at 10:45
Here are some information `Database client version: libmysql - mysqlnd 7.4.30` `PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation` `PHP version: 7.4.30 ` – Vishal Patel Aug 13 '22 at 10:52
None of this is the mysql version. However, you may be using mariadb, not mysql. So, pls clarify! – Shadow Aug 13 '22 at 11:06
I am using mariadb 10.3 – Vishal Patel Aug 13 '22 at 11:08
1

MariaDB 10.3 has [recursive common table expression](https://mariadb.com/kb/en/recursive-common-table-expressions-overview/) support. – O. Jones Aug 15 '22 at 11:24

Get category level in parent child table

0 Answers0