var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Hierarchy query
am trying to develop a hierarchy tree in MySQL such that it show something like this
Meats and Fish
This is are the levels
Printing Paper 2
Meats and Fish 1
I have never used SQL hierarchical query...i am new to this...
Can someone explain the SQL hierarchical query, how it is implemented and how can could apply it to my query
Best thing is to have a look at this Hierarchical query in MySQL: limiting parents | EXPLAIN EXTENDED which explains how this can be achieved in MySQL. Unfortunately MySQL does not have SELECT statements that allow this with START WITH ... CONNECT BY.
I'd rather be riding on the Tiger 800 or the Norton
really? i didnt know MySQL cannot run sql hierarchies. thanks for the information
depends what you mean by "run sql hierarchies"
Originally Posted by Hawi-Z
you most certainly can store hierarchies in mysql tables, and you can also quite easily retrieve hierarchical information
(the ease is largely determined by which model you implement)
i think what you might have been trying to say is that mysql does not support query recursion, but recursion is only one way to retrieve a hierarchy