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 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 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! 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. Link to comment https://forums.phpfreaks.com/topic/184137-mysql-database-design-tool/#findComment-972955 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.