mySQL integer types

Bob Sneidar bobs at twft.com
Tue Jan 17 15:11:30 EST 2012


Oh right duh that makes sense. I have no idea where I got that.

Bob


On Jan 17, 2012, at 11:47 AM, Pete wrote:

> 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>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list