存储过程、函数、触发器等

MySql

delimiter $$
create procedure zhshuo(in username char(20),in pwd char(20),out maxid int)
begin
insert into t_user(username,pwd,gid) values(username,pwd,0);
select max(id) into maxid from t_user;
end$$
delimiter ;

delimiter $$
create function strsub(str char(20))
returns char
begin 
 declare temp char(10);
 select substring(str,0,5) into temp;
  return temp;
end $$
delimiter ;

delimiter $$
create trigger useraddt before insert/update/delete on t_user for each row 
begin
set new.gid = 10;
end$$
delimiter ;

Oracle

create sequence user_seq
increment by 1
start with 1
minvalue 1 nomaxvalue
nocycle

create or replace procedure testpro(name in varchar,pwd in varchar,res out int)
is
begin
insert into t_user(id,username,pwd) values (user_seq.nextval,name,pwd);
end;

--触发器和函数与mySql差不多