mysql5.0+存储过程示例

BEGIN
    #Routine body goes here...
    declare n bigint;  
    DECLARE t_error INTEGER DEFAULT 0;  
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;
    
    START TRANSACTION;
    set n = 1;  
    while n <= 1000  
    do  
        insert into cs_users(student_id) values(n);  
        set n = n + 1;  
    end while;   
 
     IF t_error = 1 THEN  
            ROLLBACK;  
        ELSE  
            COMMIT;  
     END IF;   

    SELECT t_error;

END