BEGIN
set @uid=userid;
set @tag=tag;
set @tname=tname;
set @bpe=beginPage;
set @epe=endPage; set @c=CONCAT('select distinct `user_friends_info`.`u_friends_id`, `user_friends_info`.Goodfriends ,`user_inf`.`user_id`,`user_inf`.nick_name,`user_inf`.user_sex,`user_inf`.school,`user_inf`.`marriage`,`user_inf`.`zhiye`,`user_inf`.`address`,`user_inf`.`user_image`,
`user_inf`.`yule`,`user_inf`.`canyin`,`user_inf`.`chongwu`,`user_inf`.`gouwu`, `user_inf`.`xPoint`,`user_inf`.`yPoint`,`user_inf`.`user_sex` ,`likedish_tag`.`tname`from `user_inf` LEFT join `user_friends_info` on `user_friends_info`.`Goodfriends` = `user_inf`.`user_id` JOIN ',@tag,' ON `user_friends_info`.`Goodfriends`=',@tag,'.u_id
where ',@tag,'.tname like "%',@tname,'%" AND `user_friends_info`.`Uid` =? LIMIT ?,?;'); prepare st from @c; EXECUTE st using @uid,@bpe,@epe; DEALLOCATE prepare st; END
我要算这个sql语句的值的个数,应该怎么写?
因为有拼字符串,所以不知该怎么写了,谢谢
set @uid=userid;
set @tag=tag;
set @tname=tname;
set @bpe=beginPage;
set @epe=endPage; set @c=CONCAT('select distinct `user_friends_info`.`u_friends_id`, `user_friends_info`.Goodfriends ,`user_inf`.`user_id`,`user_inf`.nick_name,`user_inf`.user_sex,`user_inf`.school,`user_inf`.`marriage`,`user_inf`.`zhiye`,`user_inf`.`address`,`user_inf`.`user_image`,
`user_inf`.`yule`,`user_inf`.`canyin`,`user_inf`.`chongwu`,`user_inf`.`gouwu`, `user_inf`.`xPoint`,`user_inf`.`yPoint`,`user_inf`.`user_sex` ,`likedish_tag`.`tname`from `user_inf` LEFT join `user_friends_info` on `user_friends_info`.`Goodfriends` = `user_inf`.`user_id` JOIN ',@tag,' ON `user_friends_info`.`Goodfriends`=',@tag,'.u_id
where ',@tag,'.tname like "%',@tname,'%" AND `user_friends_info`.`Uid` =? LIMIT ?,?;'); prepare st from @c; EXECUTE st using @uid,@bpe,@epe; DEALLOCATE prepare st; END
我要算这个sql语句的值的个数,应该怎么写?
因为有拼字符串,所以不知该怎么写了,谢谢
select distinct `user_friends_info`.`u_friends_为
select count(distinct user_friends_info) into @cnt ...之后@cnt就是要求的值!