Mysql 存储过程小例子

创建有输入 无输出的存储过程

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存储过程小例子