A many-to-many is generally best accomplished with a third linking
table which contains the ids of the 2 records being linked ie.
create table tflink (
flightid int;
teacherid int;
);
On Fri, Mar 23, 2012 at 10:28 PM, Mark Phillips
wrote:
> My question is not specific to MySQL, even though I am
My question is not specific to MySQL, even though I am using a MySQL db for
this project. 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
t
4.2.3, the multi-DBMS IDE now available!
>
> Ladies, gentlemen,
>
> Upscene Productions is proud to announce the next version
> of the popular Windows-based multi-DBMS development tool:
>
> " Database Workbench 4.2.3 Pro "
>
>
> For more information, se
com/go/?go=news&id=20120323
Today's release includes the FREE Lite Editions.
For a full list of fixes in this release, see:
http://www.upscene.com/go/?go=tracker&v=4.2.3&id=3
http://www.upscene.com/go/?go=tracker&v=4.2.2&id=3
http://www.upscene.com/go/?go=tracker&v=4
