Re: Non-Sequential Primary Key Index

2002-02-21 Thread Arjen Lentz
Hi Byron, On Fri, 2002-02-22 at 03:23, Byron Scott wrote: > I have the following table: > > CREATE TABLE phpSP_users ( >primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, > [...] >PRIMARY KEY (primary_key), >KEY user (user), >KEY primary_key (primary_key) > );

RE: Non-Sequential Primary Key Index

2002-02-21 Thread Rick Emery
This is not a problem. Please help me to understand: why would you WANT the primary key field to be updated? I ask, because if the fields of other tables refer to the primary keys of phpSP_users and then the primary key of phpSP_users was updated due to deletions; the result would be that those