你的位置:首页 > 软件开发 > 数据库 > WITH RECURSIVE and MySQL

WITH RECURSIVE and MySQL

发布时间:2016-06-30 08:00:03
WITH RECURSIVE and MySQLIf you have been using certain DBMSs, or reading recent versions of the SQL standard, you are probably aware of the ...

WITH RECURSIVE and MySQL

If you have been using certain DBMSs, or reading recent versions of the SQL standard, you are probably aware of the so-called “WITH clause” of SQL. Some call it Subquery Factoring. Others call it Common Table Expression. A form of the WITH CLAUSE, WITH RECURSIVE”, allows to design a recursive query: a query which repeats itself again and again, each time using the results of the previous iteration. This can be quite useful to produce reports based on hierarchical data. And thus is an alternative to Oracle’s CONNECT BY. MySQL does not natively support WITH RECURSIVE, but it is easy to emulate it with a generic, reusable stored procedure. Read the full article here…

http://guilhembichot.blogspot.co.uk/2013/11/with-recursive-and-mysql.html

 

If you have been using certain DBMSs, or reading recent versions of the SQL standard, you are probably aware of the so-called "WITH clause" of SQL. Some call it Subquery Factoring. Others call it Common Table Expression. In its simplest form, this feature is a kind of "boosted derived table".

原标题:WITH RECURSIVE and MySQL

关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。