mysqlÓαê±éÀúÎÊÌâ...

CREATE PROCEDURE `UserCenterAction`(uId int,timeArea date) 

BEGIN 

DECLARE notInIds varchar(255 ); 
DECLARE userLocation varchar(10); 

DECLARE notFriendIds varchar(255 ); 
DECLARE differentLocaleIds varchar(255 ); 

DECLARE notFriendActionIdTemp int; 
DECLARE notFriendActionOwnerIdTemp int; 

DECLARE differentLocaleActionIdTemp int; 
DECLARE differentLocaleActionOwnerIdTemp int; 

DECLARE isFriend int ; 
DECLARE isSameArea int default 0; 

DECLARE notFriendCount int ; 
DECLARE differentLocationCount int default 0; 


DECLARE onlyFriendCur CURSOR for select id,Creater_id from member_action where display_flag='Y' and Create_time > timeArea and permission_code="-4"; 

DECLARE netWorkAndFriendCur CURSOR for select id,Creater_id from member_action where display_flag='Y' and Create_time > timeArea and permission_code="-3"; 

select count(*) into notFriendCount from member_action where display_flag='Y' and Create_time > timeArea and permission_code='-4'; 

select Location into userLocation from member where userId=uId ; 

open onlyFriendCur; 
  WHILE notFriendCount > 0 DO 
  fetch onlyFriendCur into notFriendActionIdTemp,notFriend