Oops. Never mind.
V
On Sat, Dec 5, 2009 at 1:19 PM, Victor Subervi wrote:
> Hi;
>
> mysql> insert into categories (Category, Parent) values ('test', NULL);
> ERROR 1062 (23000): Duplicate entry '0' for key 1
> mysql> describe categories;
> +--+-+--+-+-+
Hi;
mysql> insert into categories (Category, Parent) values ('test', NULL);
ERROR 1062 (23000): Duplicate entry '0' for key 1
mysql> describe categories;
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+
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
I am trying to create a table (projects) with the following basic column structure:
id (primary key)
id_client
id_clientkey
The ideas is that I will fill it with data like this:
table: projects
id id_client id_clientkey
-
1 1 1
2
From: Chetan Lavti <[EMAIL PROTECTED]>
> 1. When I am inserting the values and the Query fails, the increment
> should not took place and
It doesn't.
> 2. When I delete a particular row from the table there should not be any
> gap in the auto increment sequence.
This doesn't work. Although y
At 0:44 +0530 2/26/02, Chetan Lavti wrote:
>hi,
>I creating a table where I am using one field as Auto Increment. I want
>to know two things or rather I want to do to thinks for the same column
>
>1. When I am inserting the values and the Query fails, the increment
>should not took place and
>2. W
: auto increment problem
hi,
I creating a table where I am using one field as Auto Increment. I want
to know two things or rather I want to do to thinks for the same column
1. When I am inserting the values and the Query fails, the increment
should not took place and
2. When I delete a particular row
hi,
I creating a table where I am using one field as Auto Increment. I want
to know two things or rather I want to do to thinks for the same column
1. When I am inserting the values and the Query fails, the increment
should not took place and
2. When I delete a particular row from the table ther
14 matches
Mail list logo
