代码就在这里了 麻烦看下哪里错了!delimiter //create procedure seller_clearing (in order_id int,in money_paid decimal,in seller_id int,in add_time date)begin
declare seller_no,seller_pid,seller_ppid,commission_rate int;
set seller_no= ( select cate_no from b2c_tbl_seller where seller_id=(select seller_id from b2c_tbl_order_info where order_id=2369));
if(seller_no=1 or seller_no=5)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.25,add_time,25,0);
end if;
if(seller_no=2 or seller_no=4)then
set seller_pid=(select parent_id from b2c_seller_id where seller_id=seller_id);
if(seller_ppid != 0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.2,add_time,20,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.05,add_time,5,0);
end if;
end if;
if(seller_no=3)then
set seller_pid=(select parent_id from b2c_seller_id where seller_id=seller_id);
set seller_ppid=(select parent_id from b2c_seller_id where seller_id=seller_pid);
if(seller_pid!=0 and seller_ppid!=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_ppid,money_paid*0.05,add_time,5,0);
end if
if(seller_pid!=0 and seller_ppid=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.1,add_time,10,0);
end if;
if(seller_pid=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
end if;
end if;end;// 错误信息是: 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 'if(seller_pid !=0 and seller_ppid=0)then insert into b2c_tbl_commission_settleme' at line 24
declare seller_no,seller_pid,seller_ppid,commission_rate int;
set seller_no= ( select cate_no from b2c_tbl_seller where seller_id=(select seller_id from b2c_tbl_order_info where order_id=2369));
if(seller_no=1 or seller_no=5)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.25,add_time,25,0);
end if;
if(seller_no=2 or seller_no=4)then
set seller_pid=(select parent_id from b2c_seller_id where seller_id=seller_id);
if(seller_ppid != 0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.2,add_time,20,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.05,add_time,5,0);
end if;
end if;
if(seller_no=3)then
set seller_pid=(select parent_id from b2c_seller_id where seller_id=seller_id);
set seller_ppid=(select parent_id from b2c_seller_id where seller_id=seller_pid);
if(seller_pid!=0 and seller_ppid!=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_ppid,money_paid*0.05,add_time,5,0);
end if
if(seller_pid!=0 and seller_ppid=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.1,add_time,10,0);
end if;
if(seller_pid=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
end if;
end if;end;// 错误信息是: 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 'if(seller_pid !=0 and seller_ppid=0)then insert into b2c_tbl_commission_settleme' at line 24
declare seller_no,seller_pid,seller_ppid,commission_rate int;
set seller_no= ( select cate_no from b2c_tbl_seller where seller_id=(select seller_id from b2c_tbl_order_info where order_id=2369));
if(seller_no=1 or seller_no=5)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.25,add_time,25,0);
end if;
if(seller_no=2 or seller_no=4)then
set seller_pid=(select parent_id from b2c_seller_id where seller_id=seller_id);
if(seller_ppid != 0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.2,add_time,20,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.05,add_time,5,0);
end if;
end if;
if(seller_no=3)then
set seller_pid=(select parent_id from b2c_seller_id where seller_id=seller_id);
set seller_ppid=(select parent_id from b2c_seller_id where seller_id=seller_pid);
if(seller_pid!=0 and seller_ppid!=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_ppid,money_paid*0.05,add_time,5,0);
end if;
if(seller_pid!=0 and seller_ppid=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.1,add_time,10,0);
end if;
if(seller_pid=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
end if;
end if;end;//
'截至2010-08-09 10:18:45 用户结帖率0.00%当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖
end if ;
if(seller_pid!=0 and seller_ppid=0)then
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_id,money_paid*0.1,add_time,10,0);
insert into b2c_tbl_commission_settlements(seller_id,commission_amount,settlements_lap_start_date,commission_rate,is_balanced) values(selller_pid,money_paid*0.1,add_time,10,0);
end if;