Web lists-archives.com

Re: Sequence Numbering

> If the return value of the UPDATE stmt is zero, the following stmt is ran:

By return value I assume you mean "rows affected" ?

> This is working great, and has been for many years; however,
> today I noticed it was not working on a particular MySQL server.

By "not working" what exactly is the failure mode?

Not getting 0 rows affected?  0 rows affected not triggering
subsequent INSERT? Something else?

Note: It would make me uneasy to use LAST_INSERT_ID()
where there is no AUTO_INCREMENT column myself...

Good luck,

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql