MySQL
-
编辑 删除
mySQL 中的游标简单使用
例一：DELIMITER $$ DROP PROCEDURE IF EXITS cursor_example$$ CREATE PROCEDURE cursor_example() READS SQL DATA BEGIN DECLA...
-
编辑 删除
mySQL 中的游标使用简单一例
delimiter $$drop procedure if exists P_UpdateCourse;$$CREATE PROCEDURE P_UpdateCourse ( pSNM varchar(45), pResult int)BEGIN DECLARE pSNO INT; DECLARE pBase INT; DECLARE CUR1 CURSOR FOR select SNO from student; DECLARE CONTINUE HA...
-
编辑 删除
SQL递归查询(with cte as)
转： 2011-02-15 16:41 by 忧忧夏天, 代码with cte as(select Id,Pid,DeptName,0 as lvl from Departmentwhere Id = 2union allselect d.Id,d.Pid,d.DeptName,lvl+1 from cte c inner join Department don c.Id = d.Pid)select * from cte1 表结构Id Pid DeptName----------- -------...
