Home >Database >Mysql Tutorial >mysql-使用MYSQL实现oracle start with connect by递归树查询

mysql-使用MYSQL实现oracle start with connect by递归树查询

WBOY
WBOYOriginal
2016-06-06 09:34:393040browse

mysql递归oracle

代码如下,如何修改,感谢

DELETE FROM SFL_YWZYFL WHERE YWZYFL_ID IN (SELECT YWZYFL_ID FROM SFL_YWZYFL START WITH YWZYFL_ID IN(:ids) CONNECT BY PRIOR YWZYFL_ID=SFL_YWZYFL_ID)
不要沉啊!

图片说明

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn