9 Nov
2004
9 Nov
'04
2:30 p.m.
In fact mysql does allow multi-column primary keys, I just searched the documentation on the mysql site:-
A PRIMARY KEY can be a multiple-column index. However, you cannot create a multiple-column index using the PRIMARY KEY key attribute in a column specification. Doing so will mark only that single column as primary. You must use a separate PRIMARY KEY(index_col_name, ...) clause.
--
Chris Green (chris@areti.co.uk)
"Never ascribe to malice, that which can be explained by incompetence."