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)
> );
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