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 |
| 262143 |
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
@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
you I've tried every procedure out there (both on and off-list
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 will be
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,
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
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
) 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 MySQL
]
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 distribution. I
have
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
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 mysqldump to export the data from your
11 matches
Mail list logo