how to create bridge table,

[sheraz]

Hi, i am new to database designing. i have to create a bridge table in mysql? if you can guide me that how to do a bridge in phpMyAdmin than it will be better for me. Thanks  :'(

[Mchl]

What do you mean by 'bridge table'?

 

The only thing that comes to my mind is:

 

 

[sheraz]

i am talking about many to many relationship dude. i have to create a 3rd table to reference the 2 parent tables, you can say that it will be a foreign key 

[Ken2k7]

i am talking about many to many relationship dude. i have to create a 3rd table to reference the 2 parent tables, you can say that it will be a foreign key 

Well, don't use terms that are made up like "bridge table" because obviously it doesn't mean anything to us. I'm sorry we are not psychic. We do try to help, but if we don't understand something, we ask. You probably should be more grateful to people who are spending their free time (without pay) to help you. Don't be mad at us for your bad terminology.

[Mchl]

Chill... it was a joke. Really.. google for 'bridge table' and you won't find anything about a databases until fifth page.

 

Now. What is your problem with creating such a table? There's nothing more to it, than to creating any other table.

 

table A

-------------------

A_id, someData

1 , foo

2, bar

...

 

table B

-------------------

B_id, someOtherData

1 , spam

2, eggs

...

 

table A_to_B

-------------------

A_id, B_id

1 , 2

2, 1

1, 1

...