ber, 2010 3:28:00 PM
> Subject: Re: Discontinued AUTO_INCREMENT problem
>
> Too curious...could you share a SHOW CREATE TABLE from this table as
> requested before?
>
> Best regards.
> --
> Wagner Bianchi
>
>
> 2010/12/21 杨涛涛
>
> > Hi.
&g
PM
Subject: Re: Discontinued AUTO_INCREMENT problem
Too curious...could you share a SHOW CREATE TABLE from this table as
requested before?
Best regards.
--
Wagner Bianchi
2010/12/21 杨涛涛
> Hi.
> You can show us your show create table statement as well.
>
>
>
Too curious...could you share a SHOW CREATE TABLE from this table as
requested before?
Best regards.
--
Wagner Bianchi
2010/12/21 杨涛涛
> Hi.
> You can show us your show create table statement as well.
>
>
> 杨涛
> 我博客1:http://yueliangdao0608.cublog.cn
> My 我博客2:http://yueliangdao0608.blog.51cto
Hi.
You can show us your show create table statement as well.
杨涛
我博客1:http://yueliangdao0608.cublog.cn
My 我博客2:http://yueliangdao0608.blog.51cto.com
2010/12/20 Xavier Correyeur
> Hi everybody !
>
> A have a discontinued AUTO_INCREMENT sequence when i insert data in a table
> with a 100 (or
Hi everybody !
A have a discontinued AUTO_INCREMENT sequence when i insert data in a
table with a 100 (or more) items SELECT request.
The problem (or situation) is reproductible, you can see an example below.
Anybody could explain this to me ?
Cheers
XC
My MySQL version : Ver 14.14 Distrib 5
alter table tablename modify id int not null auto_increment primary key;
On Sat, Oct 25, 2008 at 2:48 AM, Paul <[EMAIL PROTECTED]> wrote:
> Anybody know if there's a way to change a primary key field that is not
> auto-incremented, turning on auto-increment but preserving the values that
> are cu
Anybody know if there's a way to change a primary key field
that is not auto-incremented, turning on auto-increment but
preserving the values that are currently in it?
TIA,
Paul W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
InterNetX - Andreas Prasch wrote:
Hi,
I have a master and a slave mysql server. On the master I write binlogs
needed for replication. From time to time I have chronological
auto_increment problems, here's a short explanation.
- the table structure :
| Field | Type| Null | Key | Default |
Hi,
I have a master and a slave mysql server. On the master I write binlogs
needed for replication. From time to time I have chronological
auto_increment problems, here's a short explanation.
- the table structure :
| Field | Type| Null | Key | Default | Extra |
+---+--
On Jun 23, 2004, at 8:15 AM, Michael Stassen wrote:
So, if I understand you correctly, somewhere in the middle of a 20,000
row insert, a row gets inserted with auto_increment id = 87,123,456,
say, then the next row tries to insert with the value 87,123,457 but
fails. You fix this by skipping th
So, if I understand you correctly, somewhere in the middle of a 20,000 row
insert, a row gets inserted with auto_increment id = 87,123,456, say, then
the next row tries to insert with the value 87,123,457 but fails. You fix
this by skipping the next value with
ALTER TABLE yourtable AUTO_INCR
On Jun 18, 2004, at 5:31 PM, Scott Haneda wrote:
While I do not know why, I would suggest you simply drop the PK and
recreate
it, this should be a whole lot faster than the alter.
This took the same amount of time as the alter table (a little longer
actually). The documentation says that in late
Robert A. Rosenberg wrote:
At 13:37 -0400 on 06/19/2004, Michael Stassen wrote about Re:
AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a:
Finally, just to cover all the bases, that really is 87 million
inserts, not
8.7 million, right? I only ask because a MEDIUMINT column runs
At 13:37 -0400 on 06/19/2004, Michael Stassen wrote about Re:
AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a:
Finally, just to cover all the bases, that really is 87 million inserts, not
8.7 million, right? I only ask because a MEDIUMINT column runs out a little
past 8.3 millio
At 17:16 -0700 on 06/18/2004, Kevin Brock wrote about AUTO_INCREMENT
problem... ER_DUP_ENTRY? (No, it's not a one:
We have a table with a primary index which is INT NOT NULL
AUTO_INCREMENT.
After inserting ~87,000,000 entries, we started seeing error 1062,
ER_DUP_ENTRY.
You are wasting half
On Jun 19, 2004, at 10:37 AM, Michael Stassen wrote:
Something about your description doesn't quite fit, however. You say
that you are "nowhere near the limit", but you say that resetting the
"auto_increment starting point" fixes the problem. Those seem
contradictory to me.
To me as well, tha
To the best of my knowledge, AUTO_INCREMENT columns are limited only by the
size of the int, so an INT NOT NULL AUTO_INCREMENT should go to 2,147,483,647.
Something about your description doesn't quite fit, however. You say that
you are "nowhere near the limit", but you say that resetting the
On Jun 19, 2004, at 6:03 AM, Terry Riley wrote:
Just a suggestion, Kevin, but how about changing from INT to BIGINT?
I thought of trying that, but since we're nowhere near the limit even
for an INT I think changing to BIGINT is premature. I want to find out
a bit more about what's happening firs
would suggest you simply drop the PK and
recreate
it, this should be a whole lot faster than the alter.
Thanks, I'll give it a try next time the problem shows up.
My main worry is that the AUTO_INCREMENT problem is merely a symptom of
a more serious problem with the table. I've got a
Just a suggestion, Kevin, but how about changing from INT to BIGINT?
Terry
--Original Message-
> We have a table with a primary index which is INT NOT NULL
> AUTO_INCREMENT.
>
> After inserting ~87,000,000 entries, we started seeing error 1062,
> ER_DUP_ENTRY.
>
> We can ge
on 06/18/2004 05:16 PM, Kevin Brock at [EMAIL PROTECTED] wrote:
> We have a table with a primary index which is INT NOT NULL
> AUTO_INCREMENT.
>
> After inserting ~87,000,000 entries, we started seeing error 1062,
> ER_DUP_ENTRY.
>
> We can get going again after doing an ALTER TABLE to reset the
We have a table with a primary index which is INT NOT NULL
AUTO_INCREMENT.
After inserting ~87,000,000 entries, we started seeing error 1062,
ER_DUP_ENTRY.
We can get going again after doing an ALTER TABLE to reset the
auto_increment starting point, but this takes about an hour...
I've seen a
In the last episode (Aug 17), delz said:
> I'm using phpmyadmin to create database on Mysql server. I want my
> idx to start at 1800 then implement auto increment. How do i do it
> using phpmyadmin?
send the following command:
ALTER TABLE mytable AUTO_INCREMENT = 1700;
In general, phpmyadmin qu
Hi All,
Good day !!!
I'm using phpmyadmin to create database on Mysql server. I want my idx to
start at 1800 then implement auto increment. How do i do it using
phpmyadmin?
Regards,
Delz,
-
Before posting, please check:
h
I've written a C program which inserts new entries into a table
with an auto_incremented column. In testing it I created several entries,
which I then deleted by connecting to mysql from the unix command line.
The problem is, when I reset the last_insert_id from the mysql prompt, it
doe
[EMAIL PROTECTED] wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the entire text of it
Hi,
I've continued trying to solve the problem that I emailed yesterday
regarding AUTO_INCREMENT, and I just seem to be going backwards.
The sample database/software that I sent yesterday had a UNIQUE
constraint and a couple of SELECT statements. I thought that removing
them bizarrely made i
> Dear Peter,
>
> > Even if i delete the record where id=65535
> > DELETE FROM cust WHERE id=65535
> > AUTO_INCREMENT starts with 65535 and i cant add any more records.
>
> Sad, but true, MySQL "remembers" the biggest number inserted into an
> auto_increment column. If you delete the row in ques
ay, July 25, 2001 12:15 PM
Subject: Re: AUTO_INCREMENT problem in table
> Dear Peter,
>
> > Even if i delete the record where id=65535
> > DELETE FROM cust WHERE id=65535
> > AUTO_INCREMENT starts with 65535 and i cant add any more records.
>
> Sad, but true, MySQL &qu
erce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: "Peter Wiherkoski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 4:47 PM
At 4:47 PM +0200 7/25/01, Peter Wiherkoski wrote:
>Hi, got a problem:
>
>My table (part of it) looks like this:
>CREATE TABLE cust (
>id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
>name CHAR(30) NOT NULL,
>PRIMARY KEY (id)
>);
>
>When i type
>INSERT INTO cust VALUES(NULL,"Peter");
>the value of id
Hi, got a problem:
My table (part of it) looks like this:
CREATE TABLE cust (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
When i type
INSERT INTO cust VALUES(NULL,"Peter");
the value of id will increase by 1 every time i insert a record.
By "misstak
e in mySQL, but, to fix it
entirely, I had to drop the table entirely and re-create before it would let
me fix the problem. Simply deleting the negative ID record didn't fix the
problem.
>From: Gábor Lénárt <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTE
William R. Mussatto writes:
> On Wed, 14 Feb 2001, Sinisa Milivojevic wrote:
>
> can an auto_increment column also have the attribute "unsigned" safely?
>
> Sincerely,
>
> William Mussatto, Senior Systems Engineer
> CyberStrategies, Inc
> ph. 909-920-9154 ext. 27
>
>
Yes it can.
On Wed, 14 Feb 2001, Sinisa Milivojevic wrote:
> Date: Wed, 14 Feb 2001 16:21:31 +0200 (EET)
> From: Sinisa Milivojevic <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: auto_increment problem with mysql 3.23.32
snip..
>
> Hi!
On Wed, Feb 14, 2001 at 04:21:31PM +0200, Sinisa Milivojevic wrote:
> Hi!
>
> The above is actually documented behaviour.
I've just realized that it's true (checked). But it was supported by older
mysql versions and now I'm getting stuck with the old tables (MyISAM).
>
> Entering negative valu
Gábor Lénárt writes:
> On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote:
> > Hi!
> >
> > I have just tested your case on my Linux and it worked just fine.
> >
> > What OS is that and are you using our binaries. If not, please do.
>
> OK, I will (but it takes some time
On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote:
> Hi!
>
> I have just tested your case on my Linux and it worked just fine.
>
> What OS is that and are you using our binaries. If not, please do.
OK, I will (but it takes some time to download).
Till that I have got a more acc
ata is still exists
> in the table.
>
> It's very serious for me since this is a commercial site.
>
> I had to upgrade to new mysql version, since old one became unusable one
> day (a very long query was blocking mysql forever with all of idle CPU
> time used. if I
exists
in the table.
It's very serious for me since this is a commercial site.
I had to upgrade to new mysql version, since old one became unusable one
day (a very long query was blocking mysql forever with all of idle CPU
time used. if I tried to strace that mysqld process with strace -p ...,
it
40 matches
Mail list logo
