1.游标
//创建游标
declare cursorName cursor for select * from tableName;
//打开游标
open cursorName;
//通常需要配合循环语句来遍历结果集
fetch cursorName into var1,var2;
while var1!=var2
//循环体内的语句
end while;
//关闭cursor
close cursorName;
2.触发器
create trigger triggerName after|before insert|update|delete on tableName for each row
begin
//执行触发器内部语句
end