56,677
社区成员
发帖
与我相关
我的任务
分享
//定义用户变量reply_id
SELECT @reply_id:=max(rs.reply_id) FROM joye_market_uc_comment_reply rs GROUP BY reply_commentid ORDER BY reply_replytime desc LIMIT 10;
//在这里使用变量reply_id
SELECT reply_commentid,reply_userid,user_nickname as reply_nickname,
reply_content,reply_replytime FROM joye_market_uc_comment_reply r INNER JOIN joye_market_uc_userinfo ON user_id=reply_userid WHERE r.reply_id IN
(@reply_id)
String sql = "SELECT @reply_id:=max(rs.reply_id) FROM joye_market_uc_comment_reply rs GROUP BY reply_commentid ORDER BY reply_replytime desc LIMIT 10;"+
"SELECT reply_commentid,reply_userid,user_nickname as reply_nickname,
reply_content,reply_replytime FROM joye_market_uc_comment_reply r INNER JOIN joye_market_uc_userinfo ON user_id=reply_userid WHERE r.reply_id IN
(@reply_id)";
但是像这样用,每一次都会执行定义用户变量的SQL;这样,二条SQL查询效率肯定低于只查一条的SQL,我该怎么做呢?难道把定义用户变量的SQL所返回结果放在一个session中?但是我又没有用到session啊,求解......