存储过程相关

命令行执行多行存储过程
DELIMITER //
CREATE DEFINER=wxpaybase@% PROCEDURE proc_table_sequence(IN name varchar(50),OUT id bigint)
SQL SECURITY INVOKER
BEGIN
update table_sequence set sequence=sequence+1 where table_name=name;
select sequence INTO id from table_sequence where table_name = name;
select id;
END;
//

查看存储过程状态
show procedure status;