MySQL 5.0的Sequence的实现

MySQL5.0里面没有Sequence很不方便，于是……

create table t_sequence(
        id int,
        seed int,
        primary key (id)
);


create function f_seqnext()
        returns int
begin
        declare oi int;
        update t_sequence set seed = seed + 1;
        select seed into oi from t_sequence;
        return oi;
end;


create function f_seqlast()
        returns int
begin
        declare oi int;
        select seed into oi from t_sequence limit 1;
        return oi;
end;


create function f_seqreset()
        returns int
begin
        update t_sequence set seed = 0;
        return 0;
end;

 那么如何调用呢。
比如我们要给某个表的每一行，在某个列上面编号，1,2,3,4,5...
update t_goods set m_id = f_seqnext()

通过调用 f_seqreset() 来降这个sequence归零