alicilin/sql.sql

Created December 17, 2017 14:39

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/alicilin/e442233d85c3012fd950f667b5015efc.js"></script>
Save alicilin/e442233d85c3012fd950f667b5015efc to your computer and use it in GitHub Desktop.

Download ZIP

mysql recursive select

Raw

sql.sql

	select @pv:=category_id as category_id, name, parent from category
	join
	(select @pv:=19)tmp
	where parent=@pv

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment