Still unable to auto_increment!!!

2001-01-14 Thread David A. Enete
I'm about to kill this terminal! I'm using mysql 3.23.24-beta (my host's choice, not mine). I have a table... == === mysql describe users; ++--+--+-+-+--

RE: Still unable to auto_increment!!!

2001-01-14 Thread Carsten H. Pedersen
I'm about to kill this terminal! I'm using mysql 3.23.24-beta (my host's choice, not mine). I have a table... == === mysql describe users; ++--+--+-+-+--

Re: Still unable to auto_increment!!! Thanks!

2001-01-14 Thread David A. Enete
Thanks to those who replied. The solution was to drop the table and then rebuild it. It was originally populated with a negative number (yes, we know about the negative problem with auto incrementation), which caused the max value to show up. I did not know that you cannot simply delete