Re: What is incorrect for this mySQL stored procedure?

[Peter Brawley]

Ascii() returns the smallint value of the first char of a string, probably not what you have in mind.

Setting SerialNo = SerialNo+1 doesn't even guarantee uniqueness, never mind sequential values. If you really need sequential values, define an auto_increment primary key in a keys table and when you need a new serial value, take the next unused one and mark it used in a blocked transaction. Otherwise just use auto_increment, which guarantees uniqueness but not an unbroken sequence.