[BNM] mysql tinyint

Jason Bailey j.bailey at sussex.ac.uk
Mon Jan 22 12:01:16 GMT 2007


> Hi,
>
> Key fields should ALWAYS be long.
>
> Tables can quite easily get to 32767 records.
>
> - Alan

I doubt this one will as its been running for a few years (I'm told) and 
has just hit 127. I take your point though. So you don't see any problems 
other than record limits in changing from smallint to something else 
smallint, bigint....something with int on the end.

and it wasn't me honest I'm just looking at the code/database to help out a 
friend.




More information about the BNMlist mailing list. Powered by Wessex Networks