MySQL :: Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node

Posted by: Peter Brawley
Date: July 22, 2016 07:55AM

MySQL doesn't having CTEs or windowing functions, so you need stored procedures.

Listings 2, 7, 7b etc at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html are for trees in general, nit binary trees in particular, but they should get you started.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node

Omkar Khalipe

July 02, 2016 07:59AM

Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node

Rick James

July 09, 2016 10:37PM

Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node

Omkar Khalipe

July 20, 2016 04:59AM

Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node

Peter Brawley

July 22, 2016 07:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.