Question

mysql怎么创建存储过程

Answer 1

直接create procedure就可以啊

一般语法：

  CREATE PROCEDURE myproc(OUT s int)
    BEGIN
      存储过程主体;
    END

Answer 2

CREATE PROCEDURE students_copy_proc (IN ref_note VARCHAR(255))
BEGIN
REPLACE INTO students_backup
SELECT *, ref_note FROM students;
END|