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-range. I'd like to change that so that new records
get id column values in the 13,000,000 range or so ... but without
changing the values of existing records.
This is so I can combine data into another, existing table with 12
million entries, without overlapping id numbers or assigning
different ones.
I can't find how to do this on the MySQL site.
Any suggestions?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]