first. The fact that it stops at
such a low number makes me think it's not related to the size of the
field.
I saw a reference in a post (to a different mailing llist) to a tables
auto_increment limit, as though that was something different from the
max value of an INT, but I haven't run across
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
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, that's
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 your
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
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
Gerben Gieling wrote:
Dear all,
I have an auto_increment value in an innodb table. I recently introduced
a new row by mistake and removed it. I beleive I read somewhere in the
manual that an innodb table does not reuse this number by default. I
also remember vaguely that it is possible to reset
Dear all,
I have an auto_increment value in an innodb table. I recently introduced
a new row by mistake and removed it. I beleive I read somewhere in the
manual that an innodb table does not reuse this number by default. I
also remember vaguely that it is possible to reset this next
autoincrement
Hello
I am using MySQL v4.0.18. I am using the mysqldump program to do backups. I was
wondering how, if at all, does mysqldump preserver the auto_increment value?
When using phpmyadmin, there is an option to preserve the auto_increment value and the
resulting file has something like
-Original Message-
From: Tucker, Gabriel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 11:36 AM
To: Mysql General (E-mail)
Cc: Philip Antoniades (E-mail)
Subject: mysqldump and auto_increment
Hello
I am using MySQL v4.0.18. I am using the mysqldump program to do backups.
I
I would like to use MEDIUMINT UNSIGNED AUTO_INCREMENT. Over time various
rows will be deleted. What happens when auto_increment reaches the maximum
value? Will it roll over to 1? And, will it begin filling those unused
values from past deletes?
Thanks,
Mark
--
MySQL General Mailing List
I found the answer to my question by reading the online manual with user
comments.
Sorry!.
Mark
- Original Message -
From: Mark Fuller [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, May 09, 2004 12:25 AM
Subject: auto_increment question
I would like to use MEDIUMINT UNSIGNED
Leandro Melo [EMAIL PROTECTED] wrote:
If it`s a InnoDB table :-? my case
If you want to start auto_increment sequence from the beginning, you must recreate
InnoDB table.
--- Paul DuBois [EMAIL PROTECTED] escreveu: At 12:27
-0300 4/29/04, Leandro Melo wrote:
Hi,
i got a table wich its pk
At 14:48 +0300 4/30/04, Egor Egorov wrote:
Leandro Melo [EMAIL PROTECTED] wrote:
If it`s a InnoDB table :-? my case
If you want to start auto_increment sequence from the beginning, you
must recreate InnoDB table.
To add to this, I'll mention something else that is relevant in the
context
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it. Although, i'd like
that the next time i insert a row in this table, it's
index
At 12:27 -0300 4/29/04, Leandro Melo wrote:
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it. Although, i'd like
that the next time i
On Thu, 29 Apr 2004 12:27:46 -0300 (ART)
Leandro Melo [EMAIL PROTECTED] wrote:
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted
If it`s a InnoDB table :-? my case
--- Paul DuBois [EMAIL PROTECTED] escreveu: At 12:27
-0300 4/29/04, Leandro Melo wrote:
Hi,
i got a table wich its pk is an auto_increment
field.
I have 10 elements in this table, wich makes the
pk_id
field = 10.
I inserted incorrectly anoter row
Stefan Schuster [EMAIL PROTECTED] wrote:
Stefan Schuster [EMAIL PROTECTED] wrote:
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one the offline transactions. Every transaction is created in the
first table (call it t1
PROTECTED]
Sent: Friday, March 12, 2004 9:35 AM
Subject: Re: auto_increment id
Stefan Schuster [EMAIL PROTECTED] wrote:
Stefan Schuster [EMAIL PROTECTED] wrote:
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one the offline transactions. Every transaction is created in the
first table (call it t1) and then moved to t2. The id is generated using
auto_increment.
My problem is that the id's
Stefan Schuster [EMAIL PROTECTED] wrote:
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one the offline transactions. Every transaction is created in the
first table (call it t1) and then moved to t2. The id is generated
Stefan Schuster [EMAIL PROTECTED] wrote:
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one the offline transactions. Every transaction is created in the
first table (call it t1) and then moved to t2. The id is generated
Hi there.
I've a table with an auto_increment primary key. I want
to reuse keys (index numbers) that becomes vacant when
I delete entries.
How do I list the vacant keys from a table?
Example table:
1
2
5
6
9
10 = max value, next is 11.
List of vacant keys:
3
4
7
8
Thanks
Hello,
I have an application in which I am using auto_increment as a kind of sequence
replacement. The only problem I have is trying to get the auto_increment to start at a
larger number than 0.
Is auto_increment the replacement for sequences? and if so, is there a way to set the
digit
When you create the table I think you just set it..
ie- create table blah AUTO_INCREMENT=
P
-Scott Purcell [EMAIL PROTECTED] wrote: -
To: [EMAIL PROTECTED]
From: Scott Purcell [EMAIL PROTECTED]
Date: 02/09/2004 12:21PM
Subject: auto_increment pseudo sequence?
Hello,
I have
alter table AUTO_INCREMENT=x
Scott Purcell wrote:
Hello,
I have an application in which I am using auto_increment as a kind of sequence replacement. The only problem I have is trying to get the auto_increment to start at a larger number than 0.
Is auto_increment the replacement for sequences
I can't drop the table. Can't I do without dropping the table?
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
How do I reset the AUTO_INCREMENT column to some arbitrary number? My
table type is InnoDB.
Thanks.
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hassan,
- Original Message -
From: Hassan Shaikh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, February 01, 2004 5:01 PM
Subject: AUTO_INCREMENT in InnoDB
Hi,
How do I reset the AUTO_INCREMENT column to some arbitrary number? My
table type is InnoDB
Hassan Shaikh [EMAIL PROTECTED] wrote:
Hi,
How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
the method mentioned in the manual is not applicable. I am using MySQL
4.0.17.
If you want to start auto_increment sequence with value bigger than current counter
value, you can
How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
the method mentioned in the manual is not applicable. I am using MySQL
4.0.17.
Otherwise you should recreate the table.
Or, if you no longer need any of the data, simply use TRUNCATE.
Chris
--
MySQL General Mailing
Chris Boget [EMAIL PROTECTED] wrote:
How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
the method mentioned in the manual is not applicable. I am using MySQL
4.0.17.
Otherwise you should recreate the table.
Or, if you no longer need any of the data, simply use TRUNCATE
Hi,
How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
the method mentioned in the manual is not applicable. I am using MySQL
4.0.17.
Thanks.
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hi,
The following does not work for InnoDB tables. The manual says The next
AUTO_INCREMENT value you want to set for your table (MyISAM).
ALTER TABLE table_name AUTO_INCREMENT = new_value;
Any suggestions for InnoDB?
Thanks.
Hassan
On Mon, 12 Jan 2004, Hassan Shaikh wrote:
Hi,
The following does not work for InnoDB tables. The manual says The next
AUTO_INCREMENT value you want to set for your table (MyISAM).
ALTER TABLE table_name AUTO_INCREMENT = new_value;
Any suggestions for InnoDB?
Insert a row with a custom
You got to be kidding! I am sure there's a better solution.
Hassan
- Original Message -
From: Tobias Asplund [EMAIL PROTECTED]
To: Hassan Shaikh [EMAIL PROTECTED]
Cc:
Sent: Monday, January 12, 2004 9:43 PM
Subject: Re: Resetting Auto_Increment
On Mon, 12 Jan 2004, Hassan Shaikh
|
+---+--+--+-+-++
| RTLUPDATE | timestamp(14)| YES | | NULL||
| RTDESC| varchar(30) | | | ||
| RTID | tinyint(3) unsigned zerofill | | PRI | NULL| auto_increment
Hi,
can the auto_increment value be reset back to '1' withou recreate the entire
table again ?? The table would be emptied first, but we would like to reset the
auto_increment value back to '1' without having to drop and recreate the table,
if possible.
MySQL version 4.0.15 Linux
TIA
Mike,
set insert_id=1;
can the auto_increment value be reset back to '1' withou recreate the
entire table again ?? The table would be emptied first, but we would like
to reset the auto_increment value back to '1' without having to drop and
recreate the table, if possible.
Regards
more difficult than the other way.
CREATE TABLE boy (
BoyID INT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (BoyID)
);
CREATE TABLE toy (
BoyID INT NOT NULL,
ToyID INT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (BoyID,ToyID)
);
This design is without
difficult than the other way.
CREATE TABLE boy (
BoyID INT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (BoyID)
);
CREATE TABLE toy (
BoyID INT NOT NULL,
ToyID INT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (BoyID,ToyID)
);
OR
#no change here
CREATE TABLE boy (
BoyID
. We took double backups from every table we had. Then we
installed the new system and uploaded the databases. Everything was ok,
mostly. For some strange reason, some of the tables just went berjerk.
The main trouble is in the id field and it's auto_increment. Normally
when I add a new line
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use that same thing to create a the same table
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use that same thing to create
Dan Muey [EMAIL PROTECTED] wrote:
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=3D20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use
Dan Muey [EMAIL PROTECTED] wrote:
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=3D20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID
Hello group,
I have a table that I create with
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use that same thing to create a the same table on two servers.
On one
,
PRIMARY KEY (softwareID)
) TYPE=INNODB;
CREATE TABLE software_machineOSs (
softwareID CHAR(20) NOT NULL,
id INT(2) unsigned zerofill NOT NULL auto_increment,
osName CHAR(20),
osRevision CHAR(20),
INDEX (softwareID),
FOREIGN KEY (softwareID
,
- localMods BLOB,
- PRIMARY KEY (softwareID)
- ) TYPE=INNODB;
Query OK, 0 rows affected (0.04 sec)
mysql
mysql CREATE TABLE software_machineOSs (
- softwareID CHAR(20) NOT NULL,
- id INT(2) unsigned zerofill NOT NULL auto_increment
auto_increment,
osName CHAR(20),
osRevision CHAR(20),
INDEX (softwareID),
FOREIGN KEY (softwareID) REFERENCES software (softwareID) ON
DELETE CASCADE ON UPDATE CASCADE,
KEY(id),
PRIMARY KEY (softwareID, id)
) TYPE=INNODB;
insert into software
(softwareID
Hi,
I've been thinking about converting our database from MyISAM to InnoDB
and while I was in the process of testing this out I ran across a kind
of anomaly. In several of our tables, we have an auto_increment as
the second field of the primary key. For example:
CREATE TABLE test_myisam (
id1
I have a ticketing system that sets the ID of the ticket as the
LAST_INSERT_ID. By default, it was counting up from 0. I updated the
ID of the last ticket to reflect a different numbering scheme
(MM). I would like to automate this but I don't want to change
the ID of a current ticket.
Hi Jason,
For MyISAM tables only, you can manually set the auto
increment counter using the syntax:
ALTER TABLE table_name AUTO_INCREMENT = 1000
Keep in mind, however, that this does not change the
value of the LAST_INSERT_ID() since it still
represents the value last inserted. On a freshly
:
$new_increment = date('Ym') * 1 + 1;
$query = mysql_query( ALTER TABLE `$calls` AUTO_INCREMENT =
$new_increment );
if ( !$query ) {
die( Couldn't Alter Table! );
}
else{
echo Successfully updated AUTO_INCREMENT: $new_increment\n;
}
After a few tests, it seems
(),'127.0.0.1','')' |
0|
The install_id('11609031') for the table is of auto_increment and that
id is already present in the HS server.
The previous entry '11609030' is the same accross the servers. How
could this happen and why doesn't mysql just increment to '11609032
,
INSTALL_TIME,REMOTE_IP,LASTURL) values
('FRZE1002','81E7A3FBE4A64E6A8CDE92EB00B4D8B0',Now(),'127.0.0.1','')' |
0|
The install_id('11609031') for the table is of auto_increment and that
id is already present in the HS server.
The previous entry '11609030' is the same accross the servers
Hi,
Hope someone can guide me how to set the auto_increment for an integer and the
value start with 1000?
I know how to set the value start from 1 but don't know how to start from 1000
or 2000 etc. Hope somebody can help me.
Thanks.
regards,
florence
Yahoo! Games
- Who
florence florence [EMAIL PROTECTED] wrote:
Hope someone can guide me how to set the auto_increment for an integer and the
value start with 1000?
I know how to set the value start from 1 but don't know how to start from 1000
or 2000 etc. Hope somebody can help me
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Thanks.
Fernando Bernardino
On Wed, 27 Aug 2003 09:05:17 -0300
bernardaum [EMAIL PROTECTED] wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again
On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
When I need to do
On Wed, 27 Aug 2003 13:27:25 +0100
Simon [EMAIL PROTECTED] wrote:
On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Why bother? MySQL doesn't care
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois [EMAIL PROTECTED] wrote:
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I
At 17:56 +0400 8/27/03, Antony Dovgal wrote:
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois [EMAIL PROTECTED] wrote:
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field
On Wed, 27 Aug 2003 10:04:02 -0400
Paul DuBois [EMAIL PROTECTED] wrote:
Second reason still applies.
yes, but I suppose he knows what he's trying to do =)
If it's still something deemed desireable:
ALTER TABLE tbl_name AUTO_INCREMENT = 1;
yes, this is another one possible solution, but I
Thanks,
Carlos
Write a Friend said:
When using AUTO_INCREMENT, is there a way to set the starting
value.
Thanks,
Carlos
Alter Table TABLENAME AUTO_INCREMENT=1
where TABLENAME is your table.
Of course this resets it so the next use of auto increment will generate a
1
When using AUTO_INCREMENT, is there a way to set the starting
value.
Thanks,
Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Write a Friend said:
When using AUTO_INCREMENT, is there a way to set the starting
value.
Thanks,
Carlos
Alter Table TABLENAME AUTO_INCREMENT=1
where TABLENAME is your table.
Of course this resets it so the next use of auto increment will generate a
1 for the table. I use is right after
Ittay,
ALTER TABLE ... AUTO_INCREMENT=...
does not work with InnoDB type tables.
http://www.innodb.com/ibman.html#InnoDB_restrictions
For an AUTO_INCREMENT column one must always define a key to the table, and
that key must contain just the auto-increment column. InnoDB does not
support
Or drop and recreate the table (that's actually what truncate is doing)
/rudy
-Original Message-
From: Miguel Perez [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 20:08
To: [EMAIL PROTECTED]
Subject: RESETTING AUTO_INCREMENT
Hi everyone:
Does anyone know how to reset
Hi everyone:
Does anyone know how to reset the auto_increment value of certain table.
Any ideas or sugestions
Greetings in advance
_
Únete al mayor servicio mundial de correo electrónico:
http://www.hotmail.com
--
MySQL General
Miguel:
Wednesday, July 9, 2003, 3:07:33 PM, você escreveu:
---[inicio]--
MP Hi everyone:
MP Does anyone know how to reset the auto_increment value of certain table.
MP Any ideas or sugestions
MP Greetings in advance
MP
Why are you looking to reset it? If you mean resetting when there is no data in a
table, a truncate table should start the auto_increment over again. If you are
referring to recovering some auto_increment values that were previously used by no
rows now use them, it is better to avoid
hi mike
you suggested the following
If you are referring to recovering some auto_increment values that were previously
used by no rows now use them, it is better to avoid this.
how can you prevent this?
best regards
benny
Hi All,
Just a quick question: How do I set the auto increment
for a field to start from an integer other than 1.
For example, I would like to be able to have the auto
increment counter start from 1000.
Thanks,
Javan.
Javan B. [EMAIL PROTECTED] wrote:
Just a quick question: How do I set the auto increment
for a field to start from an integer other than 1.
For example, I would like to be able to have the auto
increment counter start from 1000.
Use AUTO_INCREMENT option of CREATE TABLE statement
, 2003 3:50 AM
To: [EMAIL PROTECTED]
Subject: Re: Setting default auto_increment start int
Javan B. [EMAIL PROTECTED] wrote:
Just a quick question: How do I set the auto increment
for a field to start from an integer other than 1.
For example, I would like to be able to have
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 21:09 +0200 6/16/03, Fernando Martins wrote:
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing with
the code,
of course)
No.
Using NULL
At 23:50 +0200 6/18/03, Fernando Martins wrote:
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 21:09 +0200 6/16/03, Fernando Martins wrote:
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing
Just a note on this subject. We have a field that uses 0 to mean
something special too. It was a bad idea that is on my TODO list to fix
some day. (The corresponding table used 0 to mean something special, and
then joined to the table with the autoindex. The fix is too use null in
that other table
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing with the code,
of course)
Using NULL to get the next sequence number is good enough for me and I use
quite a lot 0 for special purposes (default
# [EMAIL PROTECTED] / 2003-06-16 21:09:14 +0200:
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour?
I doubt that.
(without messing with the code, of course)
I doubt that some more.
Using NULL to get
At 21:09 +0200 6/16/03, Fernando Martins wrote:
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing with the code,
of course)
No.
Using NULL to get the next sequence number is good enough for me and I
Hi,
Short question: I understand that MySQL in some circumstances
may decide that it's faster to do a full table scan rather than use
the index to look up values.
But I miss some information on *when* this happens. Is there some
way, short of reading the source code, that one can get some more
, 10 June, 2003 04:57
Subject: Storing negative numbers in AUTO_INCREMENT
Hi,
Short question: I understand that MySQL in some circumstances
may decide that it's faster to do a full table scan rather than use
the index to look up values.
But I miss some information on *when* this happens
again with a sorry, wrong subject though...
- Rich
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: rich johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 04:57
Subject: Storing negative numbers in AUTO_INCREMENT
Hi,
Short
: Tuesday, 10 June, 2003 05:42
Subject: Re: Storing negative numbers in AUTO_INCREMENT
I hate to be the one to ask, but what's the subject have to do with the
rest of
the message? I can't see how the two are related at all.
They are not :-( I started out using an old draft (which was never sent
hi
you can reset the counter yourself with the following sql statement
ALTER TABLE tbl_name AUTO_INCREMENT = 1;
best regards
benny
- Original Message -
From: Dylan Pham [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 7:27 PM
Subject: AUTO_INCREMENT
Hi,
I am
At 10:27 -0700 6/3/03, Dylan Pham wrote:
Hi,
I am new and am wodering if anyone can point out how
to make AUTO_INCREMENT readjust the numbers so that
when you delete a row it will go back to using the
next number after the last row in the table?
If you're new, you may be thinking
Hi,
I am new and am wodering if anyone can point out how
to make AUTO_INCREMENT readjust the numbers so that
when you delete a row it will go back to using the
next number after the last row in the table?
Thank you.
Hai
__
Do you Yahoo!?
Yahoo! Calendar - Free
: Tuesday, 03 June, 2003 13:27
Subject: AUTO_INCREMENT
Hi,
I am new and am wodering if anyone can point out how
to make AUTO_INCREMENT readjust the numbers so that
when you delete a row it will go back to using the
next number after the last row in the table?
Thank you.
Hai
Check the manual for last_insert_id().
Noel Wade wrote:
Hi All,
Say I have a table with an auto_increment field that is being used at the primary key.
When I insert a new record, is there any way to easily grab the primary key value for that new record? I had another unique field that I
On Tuesday 01 April 2003 08:57, Noel Wade wrote:
Say I have a table with an auto_increment field that is being used at the
primary key.
When I insert a new record, is there any way to easily grab the primary key
value for that new record? I had another unique field that I was
originally
Hi All,
Say I have a table with an auto_increment field that is being used at the primary key.
When I insert a new record, is there any way to easily grab the primary key value for
that new record? I had another unique field that I was originally going to use to do
a select statement
In one of my tables, I have an AUTO_INCREMENT column that changes to
#Deleted in each column in Access when I add a new record. To read the
data, I just entered, I must close the table and then reopen it. In
another table when I do the same thing, I see the new AUTO_INCREMENT
number come up
Hi All
Suppose I have a table in mysql with a column name ID int(5) primary key
auto_increment
1 What happens when the upperr limit of the integer is reached?
2 What are those limits?
I am not a hardcore database person, though do some database stuff for a
company, so accept the novice question
On Thu, Feb 27, 2003 at 04:37:16PM -0600, Aman Raheja wrote:
Hi All
Suppose I have a table in mysql with a column name ID int(5) primary key
auto_increment
1 What happens when the upperr limit of the integer is reached?
Error.
I don't know the specific error, because I've never tried
At 16:37 -0600 2/27/03, Aman Raheja wrote:
Hi All
Suppose I have a table in mysql with a column name ID int(5) primary key
auto_increment
The (5) is irrelevant. That is the display width, which has nothing
to do with the range of the underlying column type.
1 What happens when the upperr limit
201 - 300 of 656 matches
Mail list logo