欧美一级色视频,簧片在线免费看,美日韩在线,成人观看网站a,亚洲欧美在线一区二区,欧美操穴,欧美综合专区

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

mysql 存儲(chǔ)過程動(dòng)態(tài)拼接參數(shù)

2025.04.20 | 1028閱讀 | 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