Re: Unique Id generation

2008-08-13 Thread R . Nils
> Why would the auto_increment not work for you? The only case where you > would have a problem is if the last record was deleted before mysql > shutdown. If you are really concerned about this unique scenario, > insert a dummy record before shutdown to guard against it and delete > the dummy reco

Re: RE: Unique Id generation

2008-08-13 Thread R . Nils
> >I try to generate a unique id for each row in a Mysql-InnoDB Table. > >Because of many deletes I can't use an auto_increment column. > >After a Mysql restart, the next value for an auto_increment-column is > >max(auto_increment-column)+1, and I need a really unique id. > > > [JS] See if the

Unique Id generation

2008-08-12 Thread R . Nils
Hi all, I try to generate a unique id for each row in a Mysql-InnoDB Table. Because of many deletes I can’t use an auto_increment column. After a Mysql restart, the next value for an auto_increment-column is max(auto_increment-column)+1, and I need a really unique id. My first solution looks