Subject | Auto Increment? |
---|---|
Author | Jason Caldwell |
Post date | 2004-04-07T07:21:40Z |
Hi
I'm a MySQL user (I bet you all hear that a lot!) - I love MySQL, but
wishing it had just half of what Firebird has. btw: I just learned about /
discovered Firebird and think it just rocks!
However, I do like the auto increment functionality in MySQL for Primary
Key's - it seems to have this same functionality in Firebird I must create a
Trigger with the incremental code.
Is this the case, or am I just no seeing things correctly? If the Trigger
event is the way to get the auto-increments for my keys, then I would like
to suggest for a near future release the concept of adding auto-increments
directly by stating so in the Index, like MySQL.
I can only imagine that this would also increase Insert performance greatly
also, as the Inserts won't have to respond to trigger events.
Thanks,
Jason
PS. Looking forward to learning more about FB --> btw: can anyone turn me on
to a good book or online reference material for FB --> it seems kind of hard
to find. Thanks again.
[Non-text portions of this message have been removed]
I'm a MySQL user (I bet you all hear that a lot!) - I love MySQL, but
wishing it had just half of what Firebird has. btw: I just learned about /
discovered Firebird and think it just rocks!
However, I do like the auto increment functionality in MySQL for Primary
Key's - it seems to have this same functionality in Firebird I must create a
Trigger with the incremental code.
Is this the case, or am I just no seeing things correctly? If the Trigger
event is the way to get the auto-increments for my keys, then I would like
to suggest for a near future release the concept of adding auto-increments
directly by stating so in the Index, like MySQL.
I can only imagine that this would also increase Insert performance greatly
also, as the Inserts won't have to respond to trigger events.
Thanks,
Jason
PS. Looking forward to learning more about FB --> btw: can anyone turn me on
to a good book or online reference material for FB --> it seems kind of hard
to find. Thanks again.
[Non-text portions of this message have been removed]