Hi!
What is a portable way of using auto incremenet for ID's? Looking at
crash-me, it seems only mysql supports AUTO_INCREMENT whereas mSQL uses
sequences, and I'm not sure how other databases handle it.
I'm writing an application in Perl using DBI and I'd like to keep it as
general as possible. Should I just do a select max() to get the largest id,
and then keep trying inserts until successful?
Thanks for any input!
Cheers,
Alex
-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: [EMAIL PROTECTED]
Internet Consultant Phone: (604) 922-4536
http://www.gossamer-threads.com Fax : (604) 926-9320
PGP Public Key: http://www.gossamer-threads.com/pgpkey.txt
Page me Online: http://wwp.mirabilis.com/1591987
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
