How to write MySQL query for TreeView or Python Hard codingOptimized MySQL query with complex calculationWeb...

Why won't the strings command stop?

Lock enemy's y-axis when using Vector3.MoveTowards to follow the player

Where is this quote about overcoming the impossible said in "Interstellar"?

Formatting a table to look nice

I can't die. Who am I?

Can a Trickery Domain cleric cast a spell through the Invoke Duplicity clone while inside a Forcecage?

Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?

Is there a frame of reference in which I was born before I was conceived?

How to set path in STY file as relative to this file path

GPL code private and stolen

Is there a full canon version of Tyrion's jackass/honeycomb joke?

How to kill a localhost:8080

Why can't we use freedom of speech and expression to incite people to rebel against government?

Canadian citizen, on US no-fly list. What can I do in order to be allowed on flights which go through US airspace?

How can neutral atoms have exactly zero electric field when there is a difference in the positions of the charges?

Quitting employee has privileged access to critical information

How to disable or uninstall iTunes under High Sierra without disabling SIP

Make me a metasequence

function only contains jump discontinuity but is not piecewise continuous

How can I handle a player who pre-plans arguments about my rulings on RAW?

Has Wakanda ever accepted refugees?

If nine coins are tossed, what is the probability that the number of heads is even?

Rationale to prefer local variables over instance variables?

How do you say “my friend is throwing a party, do you wanna come?” in german



How to write MySQL query for TreeView or Python Hard coding


Optimized MySQL query with complex calculationWeb application for a restaurantSimplify SQL query that utilizes GROUP BY and HAVING BY and uses aggregationCombine Mysql limit queryConverting from binary to unaryPerformance of summing one value from join of three tablesSelecting product variants that satisfy all option criteriaMySQL database design for easy item relationships and meta storageDjango query ManyToMany for tagged itemsPHP Laravel function to search for ads in MySQL













0












$begingroup$


enter image description here



I want to get childern of Parent with step count not all childs with SQL query.
Or how can I write algorithm for this one.



Getting all child list:::



select  id,
address,
recommendor_id from (select * from gecAccount_gecaccount
order by recommendor_id, id) gecaccount ,
(select @pv := '131') initialisation where find_in_set(recommendor_id, @pv) > 0 and @pv := concat(@pv, ',', id);








share







New contributor




Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$

















    0












    $begingroup$


    enter image description here



    I want to get childern of Parent with step count not all childs with SQL query.
    Or how can I write algorithm for this one.



    Getting all child list:::



    select  id,
    address,
    recommendor_id from (select * from gecAccount_gecaccount
    order by recommendor_id, id) gecaccount ,
    (select @pv := '131') initialisation where find_in_set(recommendor_id, @pv) > 0 and @pv := concat(@pv, ',', id);








    share







    New contributor




    Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.







    $endgroup$















      0












      0








      0





      $begingroup$


      enter image description here



      I want to get childern of Parent with step count not all childs with SQL query.
      Or how can I write algorithm for this one.



      Getting all child list:::



      select  id,
      address,
      recommendor_id from (select * from gecAccount_gecaccount
      order by recommendor_id, id) gecaccount ,
      (select @pv := '131') initialisation where find_in_set(recommendor_id, @pv) > 0 and @pv := concat(@pv, ',', id);








      share







      New contributor




      Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.







      $endgroup$




      enter image description here



      I want to get childern of Parent with step count not all childs with SQL query.
      Or how can I write algorithm for this one.



      Getting all child list:::



      select  id,
      address,
      recommendor_id from (select * from gecAccount_gecaccount
      order by recommendor_id, id) gecaccount ,
      (select @pv := '131') initialisation where find_in_set(recommendor_id, @pv) > 0 and @pv := concat(@pv, ',', id);






      python algorithm mysql





      share







      New contributor




      Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 59 secs ago









      Nizomjon HajievNizomjon Hajiev

      1




      1




      New contributor




      Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Nizomjon Hajiev is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer





          StackExchange.ifUsing("editor", function () {
          return StackExchange.using("mathjaxEditing", function () {
          StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
          StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["\$", "\$"]]);
          });
          });
          }, "mathjax-editing");

          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "196"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Nizomjon Hajiev is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcodereview.stackexchange.com%2fquestions%2f214901%2fhow-to-write-mysql-query-for-treeview-or-python-hard-coding%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Nizomjon Hajiev is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Nizomjon Hajiev is a new contributor. Be nice, and check out our Code of Conduct.













          Nizomjon Hajiev is a new contributor. Be nice, and check out our Code of Conduct.












          Nizomjon Hajiev is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Code Review Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          Use MathJax to format equations. MathJax reference.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcodereview.stackexchange.com%2fquestions%2f214901%2fhow-to-write-mysql-query-for-treeview-or-python-hard-coding%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Webac Holding Inhaltsverzeichnis Geschichte | Organisationsstruktur | Tochterfirmen |...

          Violin - Can double stops be played when the strings are not next to each other?How does the violin strings'...

          Knife as defense against stray dogsDo ultrasonic dog repellers actually work against strays and other loose...