Chris Millard
asked on
MySQL for race results
I want to create a MySQL database to hold the results of a race that will take place annually.
The details I want in the table are:-
surname, firstname, racenumber, finishtime, year
Each year, runners will be issued a unique race (bib) number. However, the same set of numbers will be used each year.
What is the best way of keeping the racenumber field unique for each year? (i.e. racenumber must be a unique number between 1 and 200 for year 2015, and then again must be a unique number between 1 and 200 for year 2016 etc)
The details I want in the table are:-
surname, firstname, racenumber, finishtime, year
Each year, runners will be issued a unique race (bib) number. However, the same set of numbers will be used each year.
What is the best way of keeping the racenumber field unique for each year? (i.e. racenumber must be a unique number between 1 and 200 for year 2015, and then again must be a unique number between 1 and 200 for year 2016 etc)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER