In article <[EMAIL PROTECTED]>,
"Dan Tappin" <[EMAIL PROTECTED]> writes:
>> -Original Message-
>> From: Harald Fuchs
>> Sent: Wednesday, September 22, 2004 9:39 AM
>> To: [EMAIL PROTECTED]
>> Subject: Re: Custom Auto-Increment Proble
> -Original Message-
> From: Harald Fuchs
> Sent: Wednesday, September 22, 2004 9:39 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Custom Auto-Increment Problem
>
> The only difference is when you delete rows inbetween. In this case
> id_calc will be less than id.
In article <[EMAIL PROTECTED]>,
"Dan Tappin" <[EMAIL PROTECTED]> writes:
> Actually it's not a total and can't be calculated.
> The idea is that as users (with individual id_client keys) add rows the id of the
> row is auto incremented for their key only.
> Example:
> If user A adds 3 rows:
> i
: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs
> Sent: Wednesday, September 22, 2004 3:24 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Custom Auto-Increment Problem
>
>
> In article <[EMAIL PROTECTED]>,
> "Dan Tappin" <[EMAIL PROTECTED]> writes:
&g
In article <[EMAIL PROTECTED]>,
"Dan Tappin" <[EMAIL PROTECTED]> writes:
> Hi Shawn,
> First off thanks for the tip. I had read that page once already but after reading
> twice again after your post I realized that the
> answer was right there. Wrapping that concept around my brain really hurt
ure newbie
out there.
Thanks again,
Dan T
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 1:29 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Custom Auto-Increment Problem
Read this: http://dev.mysql.com/doc/mysql/
Read this: http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html
and post the SHOW CREATE TABLE for your projects table if that didn't
answer your question.
Thanks!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Dan Tappin" <[EMAIL PROTECTED]> wrote on 09/21/2004