Why do you want to restrict the names to be unique?
//Anders - SQL, QUERY
-----Original Message-----
From: Shaun Bramley
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 3-5-02 20:16
Subject: Re: Simple Question relating to Indexing
I'd like to first thank Carl and Anders for your quick and very
informative
answers. I really appreciate it.
To get this staightened out, for a table specified by:
CREATE TABLE Player (
PlayerID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
TeamID INT NOT NULL,
TrophyFlag TINYINT,
RecordFlag TINYINT,
LetterID TINYINT NOT NULL,
NameFirst char(15) NOT NULL,
NameLast char(20) NOT NULL)
My primary key is obviously: playerid.
letterID, trophyflag, recordflag, and teamid can be foreign keys. They
are
not configured so right now.
An index could be created based upon NameFirst and NameLast. Which
would be
ok so long as there are not two people with the name John Smith (or
whatever)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
