Hi Bruce 01.02.02 15:41:49, Bruce Stewart <[EMAIL PROTECTED]> wrote:
>Hi Andreas, > >> >I think AUTO_INCREMENT is on a per-connection basis. So if >> you're doing >> >this across different database connections, it will reset to 0. >[snip] >> do a 'select * from <tablename> where test=1' and you will >> see that the 2 new >> values will be visible to both of the clients. > >As I understand it, this is correct, and by design. MSSQL functions in the [...] >Correct, and it should! > >Don't know if I've helped you here, or only confused you more, but this >functionality is by design, and I believe makes sense. the mail you replied to was my explanation to Richard Bolen's statement: # I think AUTO_INCREMENT is on a per-connection basis. So if you're doing # this across different database connections, it will reset to 0. My problem is somewhat different: the counter randomly resets, and that is no behaviour by design. regards Andreas mysql, sql, select --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
