I am working on a database application for Unix user accounts.
I want to be able to have a system that will provide me the next
available numeric user ID. I have created a 2 column index table that
simply includes UID and user name. This field is autoincrement and the
primary key for the
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 12:45 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Auto-increment questions...
If its an autoincrement, the next highest number will be assigned by the
db.
There is no need
(SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 2:00 PM
To: Bastien Koert; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Auto-increment questions...
OK. The problem is I don't want the next highest number.
There are gaps in the UID sequence. I need to find the next UNUSED
) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 12:45 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Auto-increment questions...
If its
On Tue, 5 Oct 2004 12:59:55 -0500, NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] wrote:
OK. The problem is I don't want the next highest number.
There are gaps in the UID sequence. I need to find the next UNUSED
number in the sequence which is rarely the highest number.
As far as I know,
On Tue, 5 Oct 2004 14:18:55 -0700, Andrew Kreps [EMAIL PROTECTED] wrote:
if (isset ($lastId) ($lastId $id - 1))
{
$returnVal = $lastId + 1;
}
Sorry, I left a bit of a bug in there. You should exit the loop at
this point, if you've found a gap.
--
PHP Database Mailing
NIPP, SCOTT V (SBCSI) wrote:
I am working on a database application for Unix user accounts.
I want to be able to have a system that will provide me the next
available numeric user ID. I have created a 2 column index table that
simply includes UID and user name. This field is
Hi peoples,
Just wondering if it's possible with mysql to start an auto-increment field
at a specified number instead of 0001?
I could always just code it in php to add another number onto it to get it
to the right start point, but leaves areas for human error to creep in!
Any help would be
On October 8, 2002 01:49 am, Gavin Nouwens wrote:
Hi peoples,
Just wondering if it's possible with mysql to start an auto-increment field
at a specified number instead of 0001?
I could always just code it in php to add another number onto it to get it
to the right start point, but leaves
CREATE TABLE table_name (ID INT NOT NULL AUTO_INCREMENT = 1 PRIMARY
KEY, ... );
---John Holmes...
-Original Message-
From: Gavin Nouwens [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:50 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Auto Increment
Hi peoples
Once again...
ALTER TABLE table1 AUTO_INCREMENT = 500
Dan
On Monday, July 29, 2002, at 10:44 PM, [EMAIL PROTECTED] wrote:
rite,
my primary key column (id) is set to auto_increment as usual which is
very
handy. But when I delete a row, the auto_increment just keeps
incrementing
why, is this question asked a lot??? anywa, thanks, i was gonna try
something like that from something i read in the mysql manual, but it only
mentioned it passing and didnt give an example or anything.
tanx
Daniel Brunner [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
Yeah, it's asked a lot!!
And I've always answered that question( it's not the only question I
answer!!! )
But Good Luck!! And your welcome!!!
Dan
On Monday, July 29, 2002, at 10:51 PM, [EMAIL PROTECTED] wrote:
why, is this question asked a lot??? anywa, thanks, i was gonna try
On Mon, 29 Jul 2002 20:44:54 -0700
Georgie Casey Georgie Casey [EMAIL PROTECTED] wrote:
rite,
my primary key column (id) is set to auto_increment as usual
which is very
handy. But when I delete a row, the auto_increment just keeps
incrementing
and there's this 'hole' left where I deleted
rite,
my primary key column (id) is set to auto_increment as usual which is very
handy. But when I delete a row, the auto_increment just keeps incrementing
and there's this 'hole' left where I deleted the row!
Apart from this looking ugly, it poses another problem. In my PHP script
where I can
If you run an optimize or a repair on your datafile
it'll set the autoincrememtn back to next number
Howard
-Original Message-
From: Daniele Baroncelli [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 June 2002 11:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] auto increment
Hi guys
de Junho de 2002 2:27
Para: [EMAIL PROTECTED]
Assunto: [PHP-DB] auto increment
Hi guys,
The auto_increment field of my MySQL table gives me 258, although the
higher value at the moment is 241.
I deleted the latest records, thinking that also the auto_increment would
decrease, but this is not.
I
Hello!!
ALTER TABLE $table1 AUTO_INCREMENT = 242
Replace the $table with your table's name and replace the end number
with what number you want.
Dan
On Thursday, June 13, 2002, at 08:27 PM, [EMAIL PROTECTED] wrote:
Hi guys,
The auto_increment field of my MySQL table gives me 258,
Hi guys,
The auto_increment field of my MySQL table gives me 258, although the
higher value at the moment is 241.
I deleted the latest records, thinking that also the auto_increment would
decrease, but this is not.
I would like to know if there is a way to bring the auto_increment back to
the
Hi all,
I'm wondering if there is a way to start an auto-increment field at a number
other than 1. I'm working on a table meant to store large amounts of users,
each with their own unique ID, but my employer wants the UIDs to be a four-
digit number, rather than starting at 1 -- but they still
]
Sent: Monday, April 22, 2002 10:21 PM
Subject: [PHP-DB] auto-increment question
Hi all,
I'm wondering if there is a way to start an auto-increment field at a number
other than 1. I'm working on a table meant to store large amounts of users,
each with their own unique ID, but my employer
Hello!!
ALTER TABLE table1 AUTO_INCREMENT = 1000;
That should do it...
You can use that anytime..
Dan
On Tuesday, April 23, 2002, at 12:21 AM, [EMAIL PROTECTED] wrote:
Hi all,
I'm wondering if there is a way to start an auto-increment field at a
number
other than 1. I'm working on a
22 matches
Mail list logo