drop procedure if exists trade_proc
DELIMITER //
create procedure trade_proc(in c_id varchar(20),in c_password varchar(20),in d_money varchar(20),in d_type varchar(20),in money_type varchar(20))
modifies SQL DATA
BEGIN
DECLARE ye DOUBLE;
START TRANSACTION;
insert into deal(cid,cpassword,dtype,dmoney,moneytype)
values(c_id,c_password,d_type,d_money,money_type);
update cardinfo set clostmoney=clostmoney-d_money where cid=c_id;
select clostmoney into ye from cardinfo where cid=c_id;
if(ye<0) THEN
select "余额不足";
rollabck;
print"交易失败"
ELSE
commit;
print"交易成功"
end if;
end;//
DEMILITER ;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter // create procedure trade_proc(in c_id varchar(20),in c_password varc' at line 2
