Re: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql

2002-06-27 Thread William R. Mussatto
On Thu, 27 Jun 2002, jason wesley upton wrote: > Date: Thu, 27 Jun 2002 14:05:34 -0500 > From: jason wesley upton <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql > > EXPLANATION: > > here&#

Re: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql

2002-06-27 Thread Gerald Clark
That is a difference in the behavior of isam and myisam tables. jason wesley upton wrote: >EXPLANATION: > >here's the pertinent piece of my sql create statement: > >ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID)); > >i have used this create statement numerous times without this "problem". in

MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql

2002-06-27 Thread jason wesley upton
EXPLANATION: here's the pertinent piece of my MySQL create statement: ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID)); i have used this create statement numerous times without this "problem". in the past, let's say i inserted 3 entries: A, B, and C. their IDs were 1,2, and 3. then i del

MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql

2002-06-27 Thread jason wesley upton
EXPLANATION: here's the pertinent piece of my sql create statement: ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID)); i have used this create statement numerous times without this "problem". in the past, let's say i inserted 3 entries: A, B, and C. their IDs were 1,2, and 3. then i delet