Home > Database > Mysql Tutorial > 项目进行中的小问题-0427

项目进行中的小问题-0427

WBOY
Release: 2016-06-07 17:44:20
Original
847 people have browsed it

区域表中有如下字段:ID,Name,ParentID。要求,当删除ID为某一值的数据时,同时删除其所有的下级数据。存储过程如下: .nocount cursors cursors cursors ()pro_AreaDelete cursors cursors 16 deallocate cursors lh_Area nocount

区域表中有如下字段:ID,香港虚拟主机,Name,服务器空间,香港虚拟主机,ParentID。要求,当删除ID为某一值的数据时,同时删除其所有的下级数据。存储过程如下:

.nocount cursors cursors cursors ()pro_AreaDelete cursors cursors 16 deallocate cursors lh_Area nocount

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template