Hi all:
I am using php4.0.3pl1 with MySQL 3.22.32 on Apache for RH Linux.

I have a table/relation of sports, where amongst other categories, are 
teams, where there can be many 'teamNames' & 'teamInfos' for one sport.

The problem here is that without the use of a composite key: 
'sportName' & 'TeamName', there can be no method of uniquely 
identifiying a row or tuple. A smuch of the info for each sport is 

Does MySQL support the use of composite keys? I am using phpMyAdmin 
2.1.0 to adminster my MySQL system, and this only seems to accept a 
single primary key for a single table.

Any advice or other methods I could possibley employ, are most welcome.


         "Believe nothing - consider everything"        
  Russ Michell
  Anglia Polytechnic University Webteam
  +44 (0)1223 363271 ext 2331

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to