mySQL integer types

[Pete]

Hi Bob,
I don't think that's true.  I think you can have it not autoincrement and
supply the primary key value yourself when you insert a row.  In fact, you
have to do that if the primary key is one of the text data types since
autoincrement doesn't make any sense in that context.
Pete

On Mon, Jan 16, 2012 at 1:25 PM, Bob Sneidar <bobs at twft.com> wrote:

> It's my understanding that a primary key MUST be AI in mySQL. A friend of
> mine gave me a query that will find the next available value in a column of
> numbers:




-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>