- 论坛徽章:
- 0
|
这是我的code有问题吗?我想alert Succus 的 !(写在call 或 这? )
- DELIMITER $$
- DROP PROCEDURE IF EXISTS `agent`.`addcom` $$
- CREATE PROCEDURE `addcom`(
- in name1 varchar(20),
- in username integer(20),
- in commission integer(20),
- in amount integer(20),
- out msg varchar(20)
- )
- begin
- declare co integer(20);
- select cno into co from client where cdname=name1;
- select co;
- insert into site_acc_order (cno,cdname,usr,commis,amt) values (co,name1,username,commission,amount);
- set msg=1;
- end $$
- DELIMITER ;
复制代码
[ 本帖最后由 dannylim86 于 2008-8-5 17:16 编辑 ] |
|