mysql - How to add more than one value to a database table row? -
i have 2 tables named event , activity. have eventid foreign key of activity table , activityid fk of event table. problem is, activity can have 1 event, event can have many activities. can add 1 value activityid column in event table. can please suggest me solution it?
you need junction table . . . eventactivities, this:
create table eventactivities (     eventactivitiesid int not null primary key auto_increment,     eventid int not null references events(eventid),     activityid int not null references activities(activityid) );   then database have 3 tables, , don't need column directly connecting activities , events.
Comments
Post a Comment