Karl Jones: /* See also */

2016-04-25T10:35:53Z

‎See also

Karl Jones: Created page with "This article discusses hierarchal data management for MySQL. == Select full path to leaf ==

 SELECT t1.name AS lev1, t2.name as lev2, t3.name as lev3, t4.name a..."

2016-02-19T15:48:49Z

Created page with "This article discusses hierarchal data management for MySQL. == Select full path to leaf == <pre> SELECT t1.name AS lev1, t2.name as lev2, t3.name as lev3, t4.name a..."

New page

This article discusses [[hierarchal data management]] for [[MySQL]].

== Select full path to leaf ==

<pre>
SELECT t1.name AS lev1, t2.name as lev2, t3.name as lev3, t4.name as lev4
FROM category AS t1
LEFT JOIN category AS t2 ON t2.parent = t1.category_id
LEFT JOIN category AS t3 ON t3.parent = t2.category_id
LEFT JOIN category AS t4 ON t4.parent = t3.category_id
WHERE t1.name = 'ELECTRONICS' AND t4.name = 'FLASH';
</pre>

Source: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/

== See also ==

* [[Database]]
* [[MySQL]]

← Older revision		Revision as of 10:35, 25 April 2016
Line 18:		Line 18:
	* [[Database]]		* [[Database]]
	* [[MySQL]]		* [[MySQL]]
		+
		+	[[Category:Computing]]
		+	[[Category:Databases]]
		+	[[Category:MySQL]]

Hierarchal data management (MySQL) - Revision history

Karl Jones: /* See also */

Karl Jones: Created page with "This article discusses hierarchal data management for MySQL. == Select full path to leaf ==
SELECT t1.name AS lev1, t2.name as lev2, t3.name as lev3, t4.name a..."