May 13th, 2003, 04:27 PM
|
|
Junior Member
|
|
Join Date: Nov 2002
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
MySQL Many to Many Relationships
Greetings...
I have been working with mySQL 4.0.8 and in addition to some 1:m relationships i want to implement m:n, many to many
by means of a intermediate-bridge entity...
Something like this:
track(track_id#, track_title)
album(album_id#, album_title)
track_album(track_id#, album_id#)
(a track can be found on >1 albums and one album can contain >1 tracks)
How can this be done with SQLYog....?
I know that you have to create an index for each connection to an other table but somehow this fails when i try to manage and create the relationships....Table is INNODB!
Any help will be greatly appreciated!!!!!
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
