|
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
Navigation:
[Reply to this message]
|