Re: auto_increment trouble (not the usual check || alter table solution, though)

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 |

Re: auto_increment trouble (not the usual check || alter table solution, though)

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

Re: auto_increment trouble (not the usual check || alter table solution, though)

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

Re: auto_increment trouble (not the usual check || alter table solution, though)

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

RE: auto_increment trouble (not the usual check || alter table solution, though)

: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

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

RE: Table solution

low and it worked. sorry for the inconvenience. I am short on time. sincerely, Lamar -Original Message- From: [EMAIL PROTECTED] [mailto:jurban@;urbanresearch.com] Sent: Monday, November 11, 2002 8:44 PM To: Lamar Cc: [EMAIL PROTECTED] Subject: Re: Table solution You can use mysqldum

Re: Table solution

You can use mysqldump to export the data from your webserver to a file, ftp the file, and import into your local database. There are also some tools that might help -- urSQL (http://www.urbanresearch.com/ursql), for example, can export query results directly to Excel. This means you could connect

RE: Table solution

PROTECTED] Subject: Table solution Hello All, I want to copy a table from a webserver that has MySQL database server located on it, then, ftp to my local machine to insert into my local database. any ideas on how to do this? my goal is to create an Excel spreadsheet from the table for distr

RE: Table solution

Fax: (02) 9970 5788 - -Original Message- From: Lamar [mailto:lamarts@;flash.net] Sent: Tuesday, November 12, 2002 1:15 PM To: [EMAIL PROTECTED] Subject: Table solution Hello All, I want to copy a table from a webserver that has My

Table solution

Hello All, I want to copy a table from a webserver that has MySQL database server located on it, then, ftp to my local machine to insert into my local database. any ideas on how to do this? my goal is to create an Excel spreadsheet from the table for distribution. I have created the spreadsheet