mysql存储过程一例

2014年2月21日 Eason.Cao 数据库

 

/*=========================================
/*创建一个名字为testinster15()的程序 
/*=========================================
delimiter $
create PROCEDURE testinsert15()
  BEGIN
        DECLARE v_num int;
        DECLARE V_MAX INT;
        SET v_num=0;
        SELECT MAX(PEOPLEID) INTO V_MAX FROM PEOPLE;
        REPEAT
                SET v_num = v_num + 1;
                UPDATE PEOPLE SET LASTNAME = UUID();
                UPDATE PEOPLE SET FIRSTNAME = UUID();
        UNTIL v_num = V_MAX END REPEAT;
    commit;
  END
$
delimiter

/*=========================================
/*创建一个名字为testinster150()的程序 
/*=========================================
delimiter $
create PROCEDURE testinsert150()
  BEGIN
        DECLARE v_num int;
        SET v_num=0;
        REPEAT
                SET v_num = v_num + 1;
                insert into people (name,lastname,firstname) values (uuid(),uuid(),uuid());
        UNTIL v_num > 1500001 END REPEAT;
    commit;
  END
$

 

mysql, 存储过程

一种缓解溜肩的方法 无密码情况下进入Linux的单用户root模式