Posted by Frankly on 06/19/06 22:11

> table managementbuildingrelation
> managementid buildingid [managementid+buildingid=primary key]
>
> M001 B002
> M002 B001
> M001 B003

CREATE TABLE 'RelationManagementsBuildings (
ManID int not null,
BuildingID int not null,
primary key (ManID,BuildingID))

that was actually the first time i typed something like that.

from what I understand this would create the table I need but for the life
of me i can not figure out
how to do it in the MySQL Administrator.
i am begining to wonder if i am better off droping this admin tool lol.
i can easily creat 2 primary keys once the table is made
this is hard

[Back to original message]