I have a table where two or more columns together must be unique.

How tell mysql that col-a + col-b must be unique in a row?


How do you spell indecies???

On 10/29/2010 9:46 PM, SpreadTooThin wrote:
Create a unique index on col-a + col-b.

And it can either be indicies or indexes - the latter is more commonly
used, but the former is more proper.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On 2010-10-30 03:46, SpreadTooThin wrote:
You can create a unique constraint as in

alter table t add constraint ... unique (a, b);


/Lennart

On Oct 29, 10:18*pm, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com>
wrote:
I'm using MySQLWorkbench.
Do I just check the columns I want as primary keys?
Or must it be in the sql script?

On 2010-10-30 06:39, SpreadTooThin wrote:
[...]
I have never used MySQLWorkbench so I have no idea.

There can be several candidate keys in a table, and for reasons unknown
to me, it was decided in sql that one of them should be primary, the
primary key. If there are other candidate keys you can implement them
via unique constraints.

/Lennart

In article <iag2n3$uqk$1 (AT) news (DOT) eternal-september.org>, Jerry Stuckle <jstucklex (AT) attglobal (DOT) net> wrote:
Since when is a misspelled word "more proper" than a correctly spelled one?
The correct spelling is "indices".
>

On 10/30/2010 4:05 PM, Doug Miller wrote:
Incorrect. http://dictionary.reference.com/browse/index

Both are acceptable.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On 10/30/2010 4:05 PM, Doug Miller wrote:
OOps - I see now - you are correct - I did get an extra 'e' in there.

I though you were saying indices was incorrect.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

In article <iahuol$gfp$1 (AT) news (DOT) eternal-september.org>, Jerry Stuckle <jstucklex (AT) attglobal (DOT) net> wrote:

Doug Miller wrote:
Well it would be the plural of indicius. IIRC. But I probably don't.
Latin was a long time ago, and not that interesting.