On 5/16/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi,
> with a similar structure, you can have :
> mysql> select * from users where uid >=262140;
> ++--+
> | uid| nickname |
> ++--+
> | 262140 | text |
> | 262141 | text |
> | 262142 | text |
Partha,
Partha Dutta wrote:
This may not be a very elegant solution, but you can do this just to get the
inserts going again:
ALTER TABLE users
MODIFY COLUMN uid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT;
If you don't have any negative uids, then you will be able to store 2
billion more uids.
Just o
Hi,
with a similar structure, you can have :
mysql> select * from users where uid >=262140;
++--+
| uid| nickname |
++--+
| 262140 | text |
| 262141 | text |
| 262142 | text |
| 262143 | text |
| 262144 | text |
++--+
5 rows in
Partha,
On 5/16/05, Partha Dutta <[EMAIL PROTECTED]> wrote:
> This may not be a very elegant solution, but you can do this just to get the
> inserts going again:
>
> ALTER TABLE users
> MODIFY COLUMN uid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT;
>
> If you don't have any negative uids, then you
:00 PM
> To: mysql@lists.mysql.com
> Subject: auto_increment trouble (not the usual check || alter table
> solution, though)
>
> Hi everyone,
>
> First time on the list, although I've been (quietly) a (not-so)long-time
> quiet observer. This isn't a FAQ and I can assure
Hi everyone,
First time on the list, although I've been (quietly) a (not-so)long-time
quiet observer. This isn't a FAQ and I can assure
you I've tried every procedure out there (both on and off-list) to solve it.
A couple weeks ago, I started having problems with a MyISAM table which
holds recor
