Re: row count inconsistency

2007-02-21 Thread Steve Edberg
At 10:34 AM -0600 2/21/07, Gerald L. Clark wrote: Marty Landman wrote: The table was created and then loaded and not modified in any way I'm aware of afterwards. It's on a local, only accessible by me server. Really weird thing about it is that I wrote/ran a program specifically to find any gap

Re: row count inconsistency

2007-02-21 Thread Gerald L. Clark
Marty Landman wrote: The table was created and then loaded and not modified in any way I'm aware of afterwards. It's on a local, only accessible by me server. Really weird thing about it is that I wrote/ran a program specifically to find any gaps in the id sequence - because of the size of the t

Re: row count inconsistency

2007-02-21 Thread Marty Landman
The table was created and then loaded and not modified in any way I'm aware of afterwards. It's on a local, only accessible by me server. Really weird thing about it is that I wrote/ran a program specifically to find any gaps in the id sequence - because of the size of the table it took days to r

Re: row count inconsistency

2007-02-20 Thread Steve Edberg
At 6:23 PM -0500 2/19/07, Marty Landman wrote: Hi, I've got a very large table set up and have defined the id as auto_increment. No rows have been added, deleted, or replaced since the initial load so I'd expect the row count to equal the max(id) since mysql> describe fidcid; ++

row count inconsistency

2007-02-19 Thread Marty Landman
Hi, I've got a very large table set up and have defined the id as auto_increment. No rows have been added, deleted, or replaced since the initial load so I'd expect the row count to equal the max(id) since mysql> describe fidcid; ++---+--+-+-+-