SQL
zhangzhpeng
这个作者很懒,什么都没留下…
展开
-
MySql游标使用
begin DECLARE tmp varchar(128); DECLARE no int; DECLARE primaryKEy int; DECLARE cur CURSOR FOR SELECT name FROM t_article_para_item; DECLARE CONTINUE HANDLER FOR NOT FOUND SET no=1; #当读到数据的最后一条时,设置n原创 2013-09-09 19:52:57 · 669 阅读 · 0 评论 -
Mysql 游标操作-进阶
begin DECLARE s_id int; DECLARE s_name varchar(128); DECLARE no_more_departments int; DECLARE typeID int; DECLARE cur CURSOR FOR SELECT brand_id,brand_name FROM t_article_serial where type_id=1 gr原创 2013-09-10 13:21:04 · 864 阅读 · 0 评论