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 the

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