right...
- Original Message -
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To: "Ferindo Middleton" <[EMAIL PROTECTED]>
Cc: "Dan Buettner" <[EMAIL PROTECTED]>;
Sent: Friday, October 06, 2006 6:31 PM
Subject: Re: multiple primary keys on one
You will have to UPDATE to NULL those fields, modify the aplication to
enter NULL instead of empty-string... Then add the UNIQUE INDEX...
In MySQL (unless modified) the dafault is that NULL values are
incomparable thus allowing the creation of a UNIQUE INDEX.
-- -- -- -- -- -- -- -- -- -- -- --
> I have a primary key set on a table which consists of the combination of
the
> values: firstname, lastname, and a schedule_id (BIGINT(20))... I have this
> so the records in this table do not have duplicates, being that no one
> record should have the exact same name and schedule_id identifier.
Thanks. I now have this issue where I can't create the unique index on this
table because the email_address is often times blank or unknown for a while
(The front-end_application sets is value to '' (blank) on inserts and
updates if the user doesn't enter it so instead of going in as NULL, the
fie
At 06:26 PM 10/5/2006, Ferindo Middleton wrote:
I have a primary key set on a table which consists of the combination of the
values: firstname, lastname, and a schedule_id (BIGINT(20))... I have this
so the records in this table do not have duplicates, being that no one
record should have the ex
Ferindo, you can create multiple UNIQUE indexes on a table to enforce
your data requirements.
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
Dan
On 10/5/06, Ferindo Middleton <[EMAIL PROTECTED]> wrote:
I have a primary key set on a table which consists of the combination of the
values:
AIL PROTECTED]>
To: "'Kishore Jalleda'" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, April 27, 2006 9:11 AM
Subject: RE: Multiple primary keys
Thanks all. The query I run is a subquery.
I noticed joined query run a lot faster than the sub.
This is the sub
218 classC: 357
So not having a primary key/index will slow my queries?
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 10:49 AM
To: nngau
Cc: mysql@lists.mysql.com
Subject: Re: Multiple primary keys
On 4/27/06, nngau <[EMAIL PROT
On 4/27/06, nngau <[EMAIL PROTECTED]> wrote:
>
> Can someone figure out what's going on. This is the only change
> I made to this table. Basically I don't want any duplicate rows, so
> I setup 4 fields to be my primary key.
>
> When I do a simple select query it takes nearly 30 seconds to complete.
Quoting nngau <[EMAIL PROTECTED]>:
Can someone figure out what's going on. This is the only change
I made to this table. Basically I don't want any duplicate rows, so
I setup 4 fields to be my primary key.
If you don't want any duplicate rows, use UNIQUE, all those primary keys will
just take
10 matches
Mail list logo
