0

I need your help, please.

How can a python mysql hierarchical database be made with a limited number of levels (9 levels)?

Please tell me the algorithm, I have been tormented with this for a long time, but it does not work out as expected

Or, if possible, tell me please analogues of this situation in python

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828
mekanizm
  • 13
  • 4
  • This kind of question is usually tagged [tag:hierarchical-data] on Stack Overflow. You can probably find good answers by following that tag. I wrote an answer that got a lot of upvotes: https://stackoverflow.com/a/192462/20860 – Bill Karwin Mar 19 '20 at 21:04
  • MySQL 8.x includes recursive CTEs that can walk hierarchies. Your question is, however, quite vague. Please ask a more specific question. – The Impaler Mar 19 '20 at 21:07
  • @The Impaler See, there is a referral system. It has 9 levels. Each level receives a certain percentage. Somehow you need to recreate it in some kind of database, in mysql, if possible, it is preferable. – mekanizm Mar 19 '20 at 21:11

0 Answers0