创建有输入 无输出的存储过程
mysql> CREATE PROCEDURE s_insert_produce(IN id int,IN name VARCHAR(20),IN count int)
BEGIN
SET @id=id;
SET @name =name;
SET @count=count;
SET @insertSql =CONCAT('insert into store values(?,?,?)');
PREPARE stmtinsert FROM @insertSql;
EXECUTE stmtinsert USING @id,@name,@count;
DEALLOCATE PREPARE stmtinsert;
END;
1304 - PROCEDURE s_insert_produce already exists
mysql> call s_insert_produce(16,'三星',22);
Query OK, 0 rows affected
参考博客:
CONCAT函数:点它
Mysql PREPARE存储过程调用:点它
Mysql存储过程小例子