mysql 存儲過程 動態拼接參數

CREATE DEFINER=`root`@`%` PROCEDURE `user`(

    IN var_sdate int(11),

    IN var_edate int(11)

)

BEGIN

set @wsql=CONCAT(' reg_time >= ' ,  var_sdate , ' and reg_time <= ' , var_edate);

set @querysql=CONCAT("SELECT  * FROM user where", @wsql);

PREPARE stmt FROM @querysql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

END