Msg#: 3509517 posted 9:18 am on Nov 18, 2007 (gmt 0)
Hello forums! I would like to know the queries required to operate on hierarchical datas like INSERT, SELECT, UPDATE, DELETE etc. so that the action can be done with one query. My hierarchical data are contained in the table as: ¦id¦title¦parent_id¦description¦ Thanks in advance for the suggestion.
Msg#: 3509517 posted 6:43 am on Nov 20, 2007 (gmt 0)
Any particular reason you want to do it in one query (e.g. for ad-hoc stuff)? Is it for MySQL or some other DB? You can check out this article: [dev.mysql.com ] or search for "recursive queries", or use stored procedures if your DB supports them.
You may also get better responses in the Databases forum, or the MySQL forums...