> 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
> >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
rom: Jerry Schwartz <[EMAIL PROTECTED]>
>Sent: Aug 12, 2008 9:46 AM
>To: [EMAIL PROTECTED], mysql@lists.mysql.com
>Subject: RE: Unique Id generation
>
>>I try to generate a unique id for each row in a Mysql-InnoDB Table.
>>Because of many deletes I can't use an
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 record after yo
>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 UUID() functio
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
