例如

CREATE PROCEDURE useInfo(IN u_name VARCHAR(50) CHARACTER SET gbk,OUT u_age INT) 

补充

DECLARE 语句要写在存储过程里面，否则会报错！！

DROP PROCEDURE IF EXISTS Proc;

DELIMITER //
CREATE PROCEDURE Proc() 
BEGIN
DECLARE command_not_allowed CONDITION FOR SQLSTATE '42000' ;
END//
DELIMITER ;

CALL Proc();