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

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -