2 drop table if exists ffzg_zs_seq;
4 create table ffzg_zs_seq (
5 name varchar(2) unique not null,
6 current integer unsigned not null
9 insert into ffzg_zs_seq values ('PA',100000);
10 insert into ffzg_zs_seq values ('PB',100000);
11 insert into ffzg_zs_seq values ('PC',100000);
12 insert into ffzg_zs_seq values ('PD',100000);
13 insert into ffzg_zs_seq values ('PE',100000);
14 insert into ffzg_zs_seq values ('DD',100000);
15 insert into ffzg_zs_seq values ('MR',100000);
16 insert into ffzg_zs_seq values ('DR',100000);
17 insert into ffzg_zs_seq values ('FO',100000);
18 insert into ffzg_zs_seq values ('SE',100000);
23 max(substring_index(itemcallnumber,' ',-1))
25 where substring_index(itemcallnumber,' ',1) = ffzg_zs_seq.name
28 update ffzg_zs_seq set current = 100000 where current < 100000 ;
30 select * from ffzg_zs_seq ;
34 create function ffzg_zs_nextval( seq_name varchar(2) )
35 returns integer unsigned
37 update ffzg_zs_seq set current = ( @next_val := current + 1 ) where name = seq_name ;