OT: SQL Question

Kezdőlap
Csatolmányok:
Üzenet email-ben
+ (text/plain)
+ (text/html)
+ (text/plain)
Üzenet törlése
Válasz az üzenetre
Szerző: Mark Phillips
Dátum:  
Címzett: Phoenix Linux Users
Tárgy: OT: SQL Question
I have a servlet/jsp/MySQL web site in production, and there are about
2,000 records in the flights table. One of the foreign keys is teacher_id.
Up to this point, there is a one to many relationship between teacher_id
and the data in the flights table. I need to change the data model to allow
for a many to many relationship between teacher_id and the data in the
flight table. What is the best way to do this?

Thanks,

Mark
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss