RJ Posted December 6, 2009 Share Posted December 6, 2009 I am fairly new to db, can do a single table, but now need to expand to connecting tables. Was wondering what tool do you use to design mysql db's? or even any tutorials, thx in advance, RJ Quote Link to comment https://forums.phpfreaks.com/topic/184137-mysql-database-design-tool/ Share on other sites More sharing options...
gevensen Posted December 6, 2009 Share Posted December 6, 2009 TOAD free Quote Link to comment https://forums.phpfreaks.com/topic/184137-mysql-database-design-tool/#findComment-972269 Share on other sites More sharing options...
The Little Guy Posted December 6, 2009 Share Posted December 6, 2009 This may be a good tutorial on how to optimize your tables (normalization): http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html You want to think of each table as a box that sorts things such as toys. Lets say you have three boxes: - Box 1 holds dolls - Box 2 holds balls - Box 3 holds legos You have now sorted all the toys, and it is easy for my mysql to search that box to find a specific toy! Quote Link to comment https://forums.phpfreaks.com/topic/184137-mysql-database-design-tool/#findComment-972424 Share on other sites More sharing options...
JustLikeIcarus Posted December 7, 2009 Share Posted December 7, 2009 MySQL Workbench is pretty good and its free. As mentioned above TOAD is a pretty awesome app, I use it to administer Oracle which is their target audience ie TOAD = (Tool for Oracle Application Development). But their mysql version is pretty solid. Quote Link to comment https://forums.phpfreaks.com/topic/184137-mysql-database-design-tool/#findComment-972955 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.