mysql存储过程预处理（动态sql）

delimiter //
DROP PROCEDURE IF EXISTS test_prepare;
create PROCEDURE test_prepare(userid INT,weibonum INT,msgnum INT)
BEGIN
# 预处理的语句可以是文字字符串或是用户变量
SET @sqlstr = CONCAT("insert IGNORE INTO user_count(user_id,num,msg_num)VALUES(",userid,',',weibonum,',',msgnum,")");
PREPARE stmt FROM @sqlstr;    #预处理
EXECUTE stmt;     #执行SQL
DEALLOCATE PREPARE stmt;   #释放预处理段
END


//