Hello!!
ALTER TABLE Table1 AUTO_INCREMENT = 1000;
Dan
On Friday, May 10, 2002, at 04:36 PM, [EMAIL PROTECTED] wrote:
> Is it possible to have an autoincrement field start with a number, so
> the first record would be, let's say, 1000 instead of 1? The next would
> be 1001 instead of 2, etc
what command are you using?
When posting questions, give all details...wee can't read your mind
-Original Message-
From: Daniel Broome [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 9:33 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] autoincrement
I am trying to add auto increment
hmmm, that's interesting...I believe you are right about the version glitch. I went
to another database we have running on another server, it has 3.22.32 as you do. When
I delete the last record and then add one it DID NOT reuse the number, but
incrememented!
However, v.33 IS NOT reusing num
Angie,
Is there a bug here? How do you "re-add" a fourth record? Is 3.22.33 a
development or a stable version?
With MySQL 3.22.32, and table type of MyISAM I did not get re-use of the
auto_increment keys , no matter where the records were deleted or inserted.
Miles
At 03:24 PM 5/10/01 -0500, An
I am also doing it on 3.23.33 with MyISAM recover options off, is that what is
happening? like I said...if I delete record one, and add a fourth record, It DOES NOT
add it as 1. But as 5. however, if I delete 4, then add a fourth again, it sets it
as 4. I'm not sure if that has anything to d
on 5/10/01 12:59 PM, Angie Tollerson ([EMAIL PROTECTED])
wrote:
> That is true if you delete a row in between other records..if you delete 2 the
> fourth record added would be 4, not 2. BUT..in the default installation of
> mysql, if you delete the last record the auto_increment will fill it's
>
[quotes restored to bottom-posting order, for clarity]
> > > > If I have a database that has three records and I delete the entire
> > > > third record, when another record is then added will the auto increment
> > > > number be 3 or 4? Thanks.
> > > I will be 3 Jeff :)
> > Only if the auto inc
That is true if you delete a row in between other records..if you delete 2 the fourth
record added would be 4, not 2. BUT..in the default installation of mysql, if you
delete the last record the auto_increment will fill it's place..trust me, I just tried
it :)
>>> CC Zona <[EMAIL PROTECTED]>
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Angie Tollerson") wrote:
> I will be 3 Jeff :)
>
>
> >>> "Jeff Oien" <[EMAIL PROTECTED]> 05/10/01 01:13PM >>>
> If I have a database that has three records and I delete the entire
> third record, when another record is then added will the aut
Jeff,
That depends - I'm assuming this is a MySql database because of
"auto_increment".
If the table is declared with "type = MYISAM" when you add the other record
the auto_increment number will be 4. If not it will be 3. This is important
if you are using the field which is auto_increment (e
I will be 3 Jeff :)
>>> "Jeff Oien" <[EMAIL PROTECTED]> 05/10/01 01:13PM >>>
If I have a database that has three records and I delete the entire
third record, when another record is then added will the auto_increment
number be 3 or 4? Thanks.
Jeff Oien
--
PHP Database Mailing List (http://www.
11 matches
Mail list logo
