Re: auto-increment stops at 127

2005-02-14 Thread Alec . Cawley
"mel list_php" <[EMAIL PROTECTED]> wrote on 14/02/2005 13:54:35: > additional test, > it is always bugging at the key 127... > I put a backup online, with until 106. > Added few test records, from key 127 it just doesn't want to increment the > auto-increment field anymore. > I'm completly lost

RE: auto-increment stops at 127

2005-02-14 Thread Mark Leith
Change the column from a TINYINT (which has a maximum value of 127), see here: http://dev.mysql.com/doc/mysql/en/numeric-types.html HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: 14 February