mysql 写法改造_sql server 存储过程写法 如何 变成MYSQL 写法

---创建存储过程，本部分全部复制粘贴至查询分析器执行即可-----createprocedureget_nxt_id_P@objtypeint,@NewSeqValuebigintoutputasbeginsetNOCOUNTONif(@objtype=0)begininsertint...

---创建存储过程，本部分全部复制粘贴至查询分析器执行即可-----

create procedure get_nxt_id_P

@objtype int,

@NewSeqValue bigint output

as

begin

set NOCOUNT ON

if(@objtype=0)

begin

insert into seq_alttrade(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_alttrade')

delete from seq_alttrade

return 1;

end

else if(@objtype=1)

begin

insert into seq_alert(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_alert')

delete from seq_alert

return 1;

end

else if(@objtype=2)

begin

insert into seq_cust(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_cust')

delete from seq_cust

return 1;

end

else if(@objtype=3)

begin

insert into seq_acct(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_acct')

delete from seq_acct

return 1;

end

else if(@objtype=4)

begin

insert into seq_trade(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_trade')

delete from seq_trade

return 1;

end

else if(@objtype=5)

begin

insert into seq_oppinfo(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_oppinfo')

delete from seq_oppinfo

return 1;

end

else if(@objtype=6)

begin

insert into seq_oppinfobank(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_oppinfobank')

delete from seq_oppinfobank

return 1;

end

else if(@objtype=7)

begin

insert into seq_custmap(SeqVal) values ('a')

set @NewSeqValue = IDENT_CURRENT('seq_custmap')

delete from seq_custmap

return 1;

end

else

begin

set @NewSeqValue =0;

return -1;

end

end

GO

请问以上的SQL server的 存储过程写法如何变成 mysql 的写法呢。

展开