9 Nov
2004
9 Nov
'04
2:49 p.m.
On 2004-11-09 13:37:44 +0000 Matt Parker matt@mpcontracting.co.uk wrote:
I don't know about mySQL (not a fan really) but in most "commercial" RDBMSs you would actually set multiple primary keys to achieve this, rather than multiple unique constraints.
MySQL is commercial, produced by MySQL AB. MySQL is a privately-held Swedish company which offers support, alternative licensing and franchising services. It's just a bit lightweight and I'm not a big fan of it.
It looks like multi-column primary keys are supported these days, from http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
--
MJR/slef My Opinion Only and not of any group I know
Creative copyleft computing - http://www.ttllp.co.uk/
Unsolicited attachments to the pipex address deleted
Will HLF fund tree-killings? http://www.thewalks.co.uk/