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.
kind regards,
bill hollett
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
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
I am trying to add auto increment to a table I have already created in
phpMyAdmin but I keeps coming up with an error.
what can I do to fix this?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
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.php.net/)