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,notFriendActionOwnerIdTemp;
SET notFriendCount = notFriendCount-1; select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp;
select notFriendActionIdTemp as 动作ID,notFriendActionOwnerIdTemp
as 动作拥有者ID,notFriendCount as 总记录数,userLocation as 用户所在地区,isFriend as 是否为朋友 ; END WHILE;
close onlyFriendCur; END;
为什么 代码中的WHILE循环只循环一次? notFriendCount 这个变量是大于1的,麻烦各位指点下,想了好久想不通
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,notFriendActionOwnerIdTemp;
SET notFriendCount = notFriendCount-1; select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp;
select notFriendActionIdTemp as 动作ID,notFriendActionOwnerIdTemp
as 动作拥有者ID,notFriendCount as 总记录数,userLocation as 用户所在地区,isFriend as 是否为朋友 ; END WHILE;
close onlyFriendCur; END;
为什么 代码中的WHILE循环只循环一次? notFriendCount 这个变量是大于1的,麻烦各位指点下,想了好久想不通
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 ; select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp;
是否有满足条件的记录
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
示例:
mysql> CREATE PROCEDURE p_bluelive()
-> BEGIN
-> DECLARE done INT DEFAULT 0;
-> DECLARE v_a INT;
-> DECLARE cur1 CURSOR FOR SELECT distinct a FROM t_bluelive;
-> DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
->
-> OPEN cur1;
-> FETCH cur1 INTO v_a;
-> WHILE done=0 DO
-> set @sqlstmt=concat('SELECT a,count(*) as N from t_bluelive wher
e a=',v_a,' INTO OUTFILE \'',v_a,'.txt\'');
-> PREPARE stmt1 FROM @sqlstmt;
-> EXECUTE stmt1 ;
-> DEALLOCATE PREPARE stmt1;
-> FETCH cur1 INTO v_a;
-> END WHILE;
-> END;
-> //
而是
select count(*) into notFriendCount from member_action where display_flag='Y' and Create_time > timeArea and permission_code='-4'; 根据notFriendCount这个值来循环,而且这个变量是大于1的
检查
select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp;
是否有满足条件的记录会影响notFriendCount的值
as 动作拥有者ID,notFriendCount as 总记录数,userLocation as 用户所在地区,
isFriend as 是否为朋友 ;动作ID 动作拥有者ID 总记录数 用户所在地区 是否为朋友
1017 2 31 319 0
isFriend 这个是另一个变量,不是用来控制循环的
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; select 'T1:',notFriendCount; WHILE notFriendCount > 0 DO
fetch onlyFriendCur into notFriendActionIdTemp,notFriendActionOwnerIdTemp;
SET notFriendCount = notFriendCount-1;
select 'T2:',notFriendCount; select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp;
select notFriendActionIdTemp as 动作ID,notFriendActionOwnerIdTemp
as 动作拥有者ID,notFriendCount as 总记录数,userLocation as 用户所在地区,isFriend as 是否为朋友 ; END WHILE;
select 'T1:',notFriendCount;
select 'T3:',notFriendCount;close onlyFriendCur; END;
T1: 31
and friend_id=notFriendActionOwnerIdTemp; 是否有满足条件的记录检查isFriend值
ECLARE notFriendActionIdTemp int;
DECLARE notFriendActionOwnerIdTemp int;
这两个变量中。fetch onlyFriendCur into notFriendActionIdTemp,notFriendActionOwnerIdTemp;
SET notFriendCount = notFriendCount-1;
然后再通过这句:select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp; 判断是否为好友,如果不是就将notFriendActionIdTemp(DECLARE onlyFriendCur CURSOR for select id,Creater_id 中的id)通过CONCAT()连接成一个VARCHAR
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; //这是onlyFriendCur游标
DECLARE onlyFriendCur CURSOR for select id,Creater_id from member_action
where display_flag='Y' and Create_time > timeArea and permission_code="-4"; //这是netWorkAndFriendCur 游标,代码中还未使用到
DECLARE netWorkAndFriendCur CURSOR for select id,Creater_id from
member_action where display_flag='Y' and Create_time > timeArea and
permission_code="-3"; #DECLARE CONTINUE HANDLER FOR NOT FOUND set notFriendCount=0;//这句注释了 select Location into userLocation from member where userId=uId ;//用于查询传入过程
的userLocation 字段 uId是传入的用户ID
//这句用于查询notFriendCount 的值
select count(*) into notFriendCount from member_action where display_flag='Y'
and Create_time > timeArea and permission_code='-4'; open onlyFriendCur;
select 'T1:',notFriendCount; WHILE notFriendCount > 0 DO
//将游标中的id,Creater_id 分别赋给notFriendActionIdTemp,notFriendActionOwnerIdTemp
fetch onlyFriendCur into notFriendActionIdTemp,notFriendActionOwnerIdTemp;
SET notFriendCount = notFriendCount-1;
select 'T2:',notFriendCount;
//这句是用来判断是否为好友,如果isFriend的值大于0则是好友
select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp; //这句是用来跟踪信息用的,真正的业务是要将不是好的情况下把notFriendActionIdTemp连接成一
个VARCHAR变量
select notFriendActionIdTemp as 动作ID,notFriendActionOwnerIdTemp
as 动作拥有者ID,notFriendCount as 总记录数,userLocation as 用户所在地区,
isFriend as 是否为朋友 ;
END WHILE;
select 'T1:',notFriendCount;
select 'T3:',notFriendCount; close onlyFriendCur;END
这是过程的创建语句...
CREATE PROCEDURE `UserCenterAction`(uId int,timeArea date)以下是两个相关连表
CREATE TABLE `member_friends` (
`id` int(11) NOT NULL auto_increment,
`Owner_id` int(11) NOT NULL default '0',
`friend_id` int(11) NOT NULL default '0',
`Is_regard` char(1) NOT NULL default '1',
`is_invitor` int(1) NOT NULL default '0',
`details` varchar(100) default NULL,
`relation_enabled` char(1) NOT NULL default 'N',
`relation_desc` mediumtext,
`my_relation_desc` text,
PRIMARY KEY (`id`),
KEY `member_firend_id` (`friend_id`),
KEY `member_owner_id` (`Owner_id`),
KEY `member_friends_Owner_id` (`friend_id`,`Owner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;CREATE TABLE `member_action` (
`id` int(11) NOT NULL auto_increment,
`Creater_id` int(11) NOT NULL default '0',
`creater_name` varchar(100) default NULL,
`creater_portrait` varchar(100) default NULL,
`Create_time` datetime NOT NULL default '0000-00-00 00:00:00',
`action_type` varchar(50) default NULL,
`content` mediumtext,
`uri` varchar(100) default NULL,
`Open_flag` char(1) NOT NULL default '',
`owner_id` int(11) NOT NULL default '0',
`where_id` int(11) NOT NULL default '0',
`where_name` varchar(200) default NULL,
`what_id` int(11) NOT NULL default '0',
`what_name` varchar(200) default NULL,
`relation_id_str` varchar(200) default NULL,
`permission_code` int(11) NOT NULL default '0',
`delete_flag` char(1) NOT NULL default 'N',
`what_delete_flag` char(1) NOT NULL default 'N',
`ignore_flag` char(1) NOT NULL default 'N',
`image` varchar(100) default NULL,
`display_flag` char(1) NOT NULL default 'Y',
`what_display_flag` char(1) NOT NULL default 'Y',
`content_ext` mediumtext,
`objcount` int(11) NOT NULL default '0',
`where_ext_id` int(11) NOT NULL default '0',
`where_ext_name` varchar(200) default NULL,
`what_ext_id` int(11) NOT NULL default '0',
`what_ext_name` varchar(200) default NULL,
`commentcount` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `SIGN_NAME` (`id`),
KEY `memberAction_createTime` (`Create_time`),
KEY `member_action_actionType` (`action_type`),
KEY `member_action_Creater_id` (`Creater_id`),
KEY `member_action_Create_time` (`Create_time`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
BEGIN
select 1;
END; 我用上面这个语句是和你的一模一样?
请给出下面的语句,以供别人搭建与你相同的环境以分析问题。方便别人也就是帮助你自己。1. 所有存储过程中用到的表的 create table 语句
2. 完整的 create PROCEDURE 语句
3. 提供一些 insert into 数据插入语句,这样别人可以直接模拟你的数据。希望你提供的语句,别人能够直接复制,粘贴使用,而不是让别人再加工。
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 Location into userLocation from member where userId=uId ; select count(*) into notFriendCount from member_action where
display_flag='Y' and Create_time > timeArea and permission_code='-4';
open onlyFriendCur;
WHILE notFriendCount > 0 DO fetch onlyFriendCur into notFriendActionIdTemp,notFriendActionOwnerIdTemp;
SET notFriendCount = notFriendCount-1; select count(*) into isFriend from member_friends where Owner_id=uId
and friend_id=notFriendActionOwnerIdTemp; select notFriendActionIdTemp as 动作ID,notFriendActionOwnerIdTemp as 动作拥有者ID,notFriendCount as 总记录数,userLocation as 用户所在地
区,isFriend as 是否为朋友 ;
END WHILE;
close onlyFriendCur;END相关联的两表转下...
2、member_action表
DROP TABLE IF EXISTS `member_action`;
CREATE TABLE `member_action` (
`id` int(11) NOT NULL auto_increment,
`Creater_id` int(11) NOT NULL default '0',
`creater_name` varchar(100) default NULL,
`creater_portrait` varchar(100) default NULL,
`Create_time` datetime NOT NULL default '0000-00-00 00:00:00',
`action_type` varchar(50) default NULL,
`content` mediumtext,
`uri` varchar(100) default NULL,
`Open_flag` char(1) NOT NULL default '',
`owner_id` int(11) NOT NULL default '0',
`where_id` int(11) NOT NULL default '0',
`where_name` varchar(200) default NULL,
`what_id` int(11) NOT NULL default '0',
`what_name` varchar(200) default NULL,
`relation_id_str` varchar(200) default NULL,
`permission_code` int(11) NOT NULL default '0',
`delete_flag` char(1) NOT NULL default 'N',
`what_delete_flag` char(1) NOT NULL default 'N',
`ignore_flag` char(1) NOT NULL default 'N',
`image` varchar(100) default NULL,
`display_flag` char(1) NOT NULL default 'Y',
`what_display_flag` char(1) NOT NULL default 'Y',
`content_ext` mediumtext,
`objcount` int(11) NOT NULL default '0',
`where_ext_id` int(11) NOT NULL default '0',
`where_ext_name` varchar(200) default NULL,
`what_ext_id` int(11) NOT NULL default '0',
`what_ext_name` varchar(200) default NULL,
`commentcount` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `SIGN_NAME` (`id`),
KEY `memberAction_createTime` (`Create_time`),
KEY `member_action_actionType` (`action_type`),
KEY `member_action_Creater_id` (`Creater_id`),
KEY `member_action_Create_time` (`Create_time`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
INSERT INTO `member_action` VALUES (1,2,'邓林生',NULL,'2009-07-01 15:21:46','NEW_MEMBER_INFO','简历、教育信息、基本信息',NULL,'',0,0,NULL,0,NULL,NULL,-1,'N','N','N',NULL,'Y','Y',NULL,0,0,NULL,0,NULL,0);
INSERT INTO `member_action` VALUES (2,3,'网站管理员',NULL,'2009-04-07 15:23:50','NEW_MEMBER_INFO','教育信息、基本信息',NULL,'',0,0,NULL,0,NULL,NULL,-1,'N','N','N',NULL,'Y','Y',NULL,0,0,NULL,0,NULL,0);
INSERT INTO `member_action` VALUES (3,4,'郑志威',NULL,'2009-05-13 09:32:31','NEW_MEMBER_INFO','基本信息',NULL,'',0,0,NULL,0,NULL,NULL,-1,'N','N','N',NULL,'Y','Y',NULL,0,0,NULL,0,NULL,0);
INSERT INTO `member_action` VALUES (4,5,'江东',NULL,'2009-07-23 18:59:23','NEW_MEMBER_INFO','简历',NULL,'',0,0,NULL,0,NULL,NULL,-1,'N','N','N',NULL,'Y','Y',NULL,0,0,NULL,0,NULL,0);
INSERT INTO `member_action` VALUES (6,2,'邓林生','/upload/2008-07-10/s_aobmnh_JWEc5DZCqlS_1215664855450.jpg','2010-03-03 13:17:01','NEW_ALBUM_PHOTO',NULL,NULL,'',0,6,'风景',0,'风景',';ALBUM_6;',-1,'N','N','N',NULL,'Y','Y','<a href=\"/photo.do?r=177\"><img src=\"/upload/2010/0303/a/s2_6_177_1267593413531.jpg\" alt=\"照片\" /></a>',1,0,NULL,0,NULL,0);
INSERT INTO `member_action` VALUES (7,2,'邓林生',NULL,'2009-04-11 00:49:40','ALBUM_PHOTO_MARK',NULL,NULL,'',0,7,NULL,2,'邓林生',';ALBUM_5;ALBUM_PHOTO_7;ALBUM_PHOTO_MARK_1;',-4,'N','N','N','/upload/2009/0411/a/s1_5_7_1239381484218.jpg','Y','Y','<p class=\"image\"><a href=\"/photo.do?r=7\"><img src=\"/upload/2009/0411/a/s1_5_7_1239381484218.jpg\" alt=\"照片\" /></a></p>',0,5,'ME',0,NULL,0);
INSERT INTO `member_action` VALUES (8,2,'邓林生',NULL,'2009-04-11 00:50:22','ALBUM_PHOTO_MARK',NULL,NULL,'',0,6,NULL,2,'邓林生',';ALBUM_5;ALBUM_PHOTO_6;ALBUM_PHOTO_MARK_2;',-4,'N','N','N','/upload/2009/0411/a/s1_5_6_1239381477388.jpg','Y','Y','<p class=\"image\"><a href=\"/photo.do?r=6\"><img src=\"/upload/2009/0411/a/s1_5_6_1239381477388.jpg\" alt=\"照片\" /></a></p>',0,5,'ME',0,NULL,0);
INSERT INTO `member_action` VALUES (10,2,'邓林生','/upload/2009/0411/u/s_aqZJJlKIYjS-yJ2irc_1239385660828.jpg','2009-04-11 01:47:40','INVITE_MEMBER',NULL,NULL,'',0,0,NULL,6,'swell',';INVITE_MEMBER_6;',-1,'N','N','N',NULL,'Y','Y',NULL,0,0,NULL,0,NULL,0);
CREATE TABLE `member_friends` (
`id` int(11) NOT NULL auto_increment,
`Owner_id` int(11) NOT NULL default '0',
`friend_id` int(11) NOT NULL default '0',
`Is_regard` char(1) NOT NULL default '1',
`is_invitor` int(1) NOT NULL default '0',
`details` varchar(100) default NULL,
`relation_enabled` char(1) NOT NULL default 'N',
`relation_desc` mediumtext,
`my_relation_desc` text,
PRIMARY KEY (`id`),
KEY `member_firend_id` (`friend_id`),
KEY `member_owner_id` (`Owner_id`),
KEY `member_friends_Owner_id` (`friend_id`,`Owner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
INSERT INTO `member_friends` VALUES (1,6,2,'0',0,'/COLLEAGUE/','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td>同事(2006 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=2\" userid=\"2\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (2,2,6,'0',0,'/COLLEAGUE/','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td>同事(2006 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=6\" userid=\"6\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (3,7,2,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2008 - 2008)<BR></td></tr>','<tr><th>描述:</th><td>同事(2008 - 2008)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=2\" userid=\"2\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (4,2,7,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2008 - 2008)<BR></td></tr>','<tr><th>描述:</th><td>同事(2008 - 2008)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=7\" userid=\"7\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (5,3,2,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2008 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2008 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=2\" userid=\"2\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (6,2,3,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2008 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2008 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=3\" userid=\"3\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (7,2,4,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2005 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2005 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=4\" userid=\"4\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (8,4,2,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2005 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2005 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=2\" userid=\"2\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (9,5,2,'0',0,'/SNS/','Y','<tr><th>描述:</th><td>通过设计联盟认识(2009)<BR></td></tr>','<tr><th>描述:</th><td>通过设计联盟认识(2009)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=2\" userid=\"2\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (10,2,5,'0',0,'/SNS/','Y','<tr><th>描述:</th><td>通过设计联盟认识(2009)<BR></td></tr>','<tr><th>描述:</th><td>通过设计联盟认识(2009)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=5\" userid=\"5\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (11,5,6,'0',0,'/SNS/','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td>通过设计联盟认识(2009) 见过面<BR><hr />等待swell确认(<a href=\"#\" rel=\"/friend/detail.do?userid=6\" userid=\"6\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (12,6,5,'0',0,'/SNS/','Y','<tr><th>描述:</th><td>通过设计联盟认识(2009) 见过面<BR></td></tr>','<tr><th>描述:</th><td>通过设计联盟认识(2009) 见过面<BR><hr />需要确认(<a href=\"#\" rel=\"/friend/detail.do?userid=5&a=confim\" userid=\"5\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (13,48,4,'0',0,'','Y','<tr><th>描述:</th><td>','<tr><th>描述:</th><td><a href=\"#\" rel=\"/friend/detail.do?userid=4\" userid=\"4\" class=\"friend_detail\">我是如何认识熊思宇的?</a></td></tr>');
INSERT INTO `member_friends` VALUES (14,4,48,'0',0,'','Y','<tr><th>描述:</th><td>','<tr><th>描述:</th><td><a href=\"#\" rel=\"/friend/detail.do?userid=48\" userid=\"48\" class=\"friend_detail\">我是如何认识swell的?</a></td></tr>');
INSERT INTO `member_friends` VALUES (15,48,34,'0',0,'','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td><hr />等待davy确认(<a href=\"#\" rel=\"/friend/detail.do?userid=34\" userid=\"34\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (16,34,48,'0',0,'','Y','<tr><th>描述:</th><td>','<tr><th>描述:</th><td><hr />需要确认(<a href=\"#\" rel=\"/friend/detail.do?userid=48&a=confim\" userid=\"48\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (17,63,69,'0',0,'/SCHOOLFELLOW/COLLEAGUE/','Y',NULL,NULL);
INSERT INTO `member_friends` VALUES (18,69,63,'0',0,'','Y',NULL,NULL);
INSERT INTO `member_friends` VALUES (19,63,64,'0',0,'/SCHOOLFELLOW/','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td>同学(2007 - 2009)<BR><hr />等待123456确认(<a href=\"#\" rel=\"/friend/detail.do?userid=64\" userid=\"64\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (20,64,63,'0',0,'/SCHOOLFELLOW/','Y','<tr><th>描述:</th><td>同学(2007 - 2009)<BR></td></tr>','<tr><th>描述:</th><td>同学(2007 - 2009)<BR><hr />需要确认(<a href=\"#\" rel=\"/friend/detail.do?userid=63&a=confim\" userid=\"63\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (21,2,48,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2009 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2009 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=48\" userid=\"48\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (22,48,2,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2009 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2009 - 现在)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=2\" userid=\"2\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (23,1282,1262,'0',0,'','N',NULL,NULL);
INSERT INTO `member_friends` VALUES (24,1262,1282,'0',0,'','N',NULL,NULL);
INSERT INTO `member_friends` VALUES (25,63,1418,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事:工作(2009 - 2010)<BR></td></tr>','<tr><th>描述:</th><td>同事:工作(2009 - 2010)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=1418\" userid=\"1418\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (26,1418,63,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事:工作(2009 - 2010)<BR></td></tr>','<tr><th>描述:</th><td>同事:工作(2009 - 2010)<BR><hr />(<a href=\"#\" rel=\"/friend/detail.do?userid=63\" userid=\"63\" class=\"friend_detail\">修改</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (27,1418,1419,'0',0,'/SNS/','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td>通过广东工业设计网认识(2010) 见过面<BR><hr />等待张三确认(<a href=\"#\" rel=\"/friend/detail.do?userid=1419\" userid=\"1419\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (28,1419,1418,'0',0,'/SNS/','Y','<tr><th>描述:</th><td>通过广东工业设计网认识(2010) 见过面<BR></td></tr>','<tr><th>描述:</th><td>通过广东工业设计网认识(2010) 见过面<BR><hr />需要确认(<a href=\"#\" rel=\"/friend/detail.do?userid=1418&a=confim\" userid=\"1418\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (29,3,1418,'0',0,'/COLLEAGUE/','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td>同事(2010 - 现在)<BR><hr />等待李四确认(<a href=\"#\" rel=\"/friend/detail.do?userid=1418\" userid=\"1418\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (30,1418,3,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2010 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2010 - 现在)<BR><hr />需要确认(<a href=\"#\" rel=\"/friend/detail.do?userid=3&a=confim\" userid=\"3\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (31,3,1419,'0',0,'/COLLEAGUE/','N','<tr><th>描述:</th><td>','<tr><th>描述:</th><td>同事(2009 - 现在)<BR><hr />等待张三确认(<a href=\"#\" rel=\"/friend/detail.do?userid=1419\" userid=\"1419\" class=\"friend_detail\">查看</a>)</td></tr>');
INSERT INTO `member_friends` VALUES (32,1419,3,'0',0,'/COLLEAGUE/','Y','<tr><th>描述:</th><td>同事(2009 - 现在)<BR></td></tr>','<tr><th>描述:</th><td>同事(2009 - 现在)<BR><hr />需要确认(<a href=\"#\" rel=\"/friend/detail.do?userid=3&a=confim\" userid=\"3\" class=\"friend_detail\">查看</a>)</td></tr>');
那个工具害我浪费一天时间...