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

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -