mysql 存儲(chǔ)過(guò)程 動(dòng)態(tài)拼接參數(shù)
2025.04.20 | 583閱讀 | 0條評(píng)論 | 數(shù)據(jù)庫(kù)
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
發(fā)表評(píng)論