DELIMITER $$DROP PROCEDURE IF EXISTS `proc_test`$$CREATE
PROCEDURE `carpo_xianjin`.`proc_test`(IN user_name VARCHAR(50), IN amount VARCHAR(20))
BEGIN
DECLARE v_balance VARCHAR(20);
SELECT balance INTO v_balance FROM userbalance WHERE USER = user_name;
IF v_balance > amount THEN
...