国产精品7777777,国产亚洲第一页,亚洲激情网,三级黄色在线免费观看,91男生福利,91男生福利,亚洲天堂福利

龍巖小程序開發(fā),龍巖分銷系統(tǒng)

mysql 存儲過程動態(tài)拼接參數(shù)

2025.04.20 | 703閱讀 | 0條評論 | 數(shù)據(jù)庫

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