subject:"Non\-Sequential Primary Key Index"

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

3 AM To: [EMAIL PROTECTED] Subject: Non-Sequential Primary Key Index I have the following table: CREATE TABLE phpSP_users ( primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, user varchar(50) NOT NULL, password varchar(30) NOT NULL, userlevel smallin

Non-Sequential Primary Key Index

2002-02-21 Thread Byron Scott

I have the following table: CREATE TABLE phpSP_users ( primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, user varchar(50) NOT NULL, password varchar(30) NOT NULL, userlevel smallint(3) DEFAULT '0' NOT NULL, service_name varchar(50) DEFAULT 'A Childs Place',