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
發表評論