#声明过程结束符号为//
DELIMITER //
#创建存储过程
CREATE PROCEDURE pname(IN col1 INT UNSIGNED,OUT col2 INT UNSIGNED)
#方法体
BEGIN
DELETE FROM users WHERE id = col1;
SELECT ROW_COUNT() INTO col2;
END;//
#声明过程结束符号为//
DELIMITER //
#创建存储过程
CREATE PROCEDURE pname(IN col1 INT UNSIGNED,OUT col2 INT UNSIGNED)
#方法体
BEGIN
DELETE FROM users WHERE id = col1;
SELECT ROW_COUNT() INTO col2;
END;//