RE: Changing range of identity column for future inserts

2005-11-15 Thread Dan Buettner
To: mysql@lists.mysql.com Subject: Changing range of identity column for future inserts Date: Tue, 15 Nov 2005 08:50:03 -0600 I would like to change one of my tables so that future inserts use a higher range of numbers for the primary key values. I have a table 'event' with column: id i

Re: Changing range of identity column for future inserts

2005-11-15 Thread Michael Stassen
mel list_php wrote: From: Dan Buettner <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Changing range of identity column for future inserts Date: Tue, 15 Nov 2005 08:50:03 -0600 I would like to change one of my tables so that future inserts use a higher range of numbers for the p

RE: Changing range of identity column for future inserts

2005-11-15 Thread mel list_php
, melanie From: Dan Buettner <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Changing range of identity column for future inserts Date: Tue, 15 Nov 2005 08:50:03 -0600 I would like to change one of my tables so that future inserts use a higher range of numbers for the primary key value

Changing range of identity column for future inserts

2005-11-15 Thread Dan Buettner
I would like to change one of my tables so that future inserts use a higher range of numbers for the primary key values. I have a table 'event' with column: id int unsigned not null auto_increment primary key Currently new records are going into the table with id column values in the 3,000,000