Re: Stored Function

[Peter Brawley]

Incomplete spec. Does the table have just one row? Otherwise, how is the func to identify which row to update? Assuming it has just the one row ...

drop table if exists master;
create table master( callno int );
insert into master set callno=1;
select callno from master;
drop function if exists callnoincr;
delimiter go
create function callnoincr() returns int deterministic
begin
  declare n int default 0;
  set n = (select callno from master);
  update master set callno=n+1;
  return (select callno from master);
end;
go
delimiter ;
select callnoincr();

Edited 1 time(s). Last edit at 01/02/2017 04:46PM by Peter Brawley.