MySQL Hierarchical Query
$30-250 USD
Pagado a la entrega
I need a MySQL hierarchical query written that returns all of the descendants of an item and the level away from the parent. I'm attaching an E-R diagram of the 2 tables, resources and collectionelements. I'm looking for all of the recursive descendants (other resources related in collectionelements) for a given resource. A resource can be of type = 'collection' or 'resource'. So if a descendant is a resource of type = 'collection' we need to continue finding descendants for that branch. Here is one place to start, but since my id values are not ascending, I think this needs modification : [login to view URL]
The deliverable should be a query that returns the resourceids of all descendants, resource title, resource type, level and indentation similar to what is shown in the link above for a given resourceid.
Nº del proyecto: #7619489
Sobre el proyecto
10 freelancers están ofertando un promedio de $117 por este trabajo
let expert do this...................................................................................................
Hello, I am akil khatri with my 25+ member team with limited skills and unlimited ideas in Game Development|iPhone|Android|Mobile App Development|PHP|Joomla|Wordpress|Javascript|Java| and |.Net|3D Animation|3D Max| wi Más
I am a professional software engineer with 9+ years of experience. I am very talented programmer with the following skills c, c++ , java ,sql,plsql, UNIX, Linux,SSH, PHP, Jsp ,Apache Server, jboss,AWS, Js , advanced j Más
Hi, I am interested to work on this SQL program. The query will be created as you asked. I hope you will consider my bid. Thanks