99麻豆久久久国产免费福利精品,国产精品成人国产乱,玖玖操,手机看片169,国产精彩视频在线观看,午夜亚洲福利视频,国产伦乱视频

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

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

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