mysql¶¯Ì¬sqlÔõôµÃµ½½á¹û?

select v_sql;
    SET @v=CONCAT(' ',v_sql) ;
    PREPARE  stmt1  from  @v;
    EXECUTE  stmt1;   
    SET alert_rowcount=FOUND_ROWS();
    DEALLOCATE PREPARE stmt1; 


Ôõô֪µÀv_sql²éѯµÃµ½µÄ½á¹û?

---

¿ÉÒÔͨ¹ý FOUND_ROWS()  À´È·¶¨ÉÏ´ÎÖ´ÐÐµÄ select Óï¾ä·µ»ØÁ˶àÉÙÐС£

---

¹þ¹þ¹þ¹þ¹þ¹þ!
ACMAIN_CHM
Õâ´ÎÔÔÀ­!


#Æ´½Ó²éѯ×ܼǼµÄSQLÓï¾ä   
set v_sqlcounts = concat('select count(*) into @recordcount from ',v_tables,v_where);   
set @sqlcounts := v_sqlcounts;   
#Ô¤´¦Àí¶¯Ì¬SQL   
prepare stmt from @sqlcounts;   
#´«µÝ¶¯Ì¬SQLÄÚ²ÎÊý   
set @s1= categoryid;   
execute stmt using @s1;   
deallocate prepare stmt;   
#»ñÈ¡¶¯Ì¬SQLÓï¾ä·µ»ØÖµ   
set recordcount = @recordcount;

---