ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!
ANN: Database Workbench 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, see http://www.upscene.com/go/?go=newsid=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=trackerv=4.2.3id=3 http://www.upscene.com/go/?go=trackerv=4.2.2id=3 http://www.upscene.com/go/?go=trackerv=4.2.1id=3 http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Database Workbench 4.2.3, the multi-DBMS IDE now available!
Any plans to add sqlite to your list of supported DBs there? I develop Android and use LAMP as the server backend. Currently I use SQLYog as I have for like 10 years. But I would really like one GUI to work on both the android sqlite and the mysql backend since they usually tie together. -Original Message- From: Martijn Tonies [mailto:m.ton...@upscene.com] Sent: Friday, March 23, 2012 2:10 AM To: mysql@lists.mysql.com; firebird-to...@yahoogroups.com Subject: ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available! ANN: Database Workbench 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, see http://www.upscene.com/go/?go=newsid=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=trackerv=4.2.3id=3 http://www.upscene.com/go/?go=trackerv=4.2.2id=3 http://www.upscene.com/go/?go=trackerv=4.2.1id=3 http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
OT: SQL Question
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 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
Re: OT: SQL Question
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 m...@phillipsmarketing.biz wrote: 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 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 -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql