Alan assumes the field is set up as an AUTOINCREMENT, which is what MySQL uses to increment integer index fields.

Kurt.




----- Original Message ----
From: Alan McDonald <alan@...>
To: firebird-support@yahoogroups.com
Sent: Friday, October 17, 2008 5:29:20 AM
Subject: RE: [firebird-support] Generator

> Hi,
>
> Sorry if this is off topic, I have been using Firebird for a long time,
> the generator is the one I
> use often too, now, I'm trying to convert a Firebird db to MySql, and I
> can not find generator
> in mysql, does anybody now what is the equivalent in mySQL? Thanks.
>
>

MySQL has no generators, you need to insert a record, then ask the server
the ID of the last record inserted. The server gives you back the ID on a
per connection basis.
Alan



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]