Rommeo Posted April 26, 2010 Share Posted April 26, 2010 Is there any software to create MySQL queries ( or to help to create/try ) ? I ll enter the tables with details (or connect to the tables) and choose the output and it will give me the query ? Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 26, 2010 Share Posted April 26, 2010 I know nothing from OSS/Freeware domain that would have such capabilities. Quote Link to comment Share on other sites More sharing options...
Rommeo Posted April 30, 2010 Author Share Posted April 30, 2010 or i can create temporary tables to try sql queries ? so i can learn about it ? Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 30, 2010 Share Posted April 30, 2010 Well... you can... But what's the point? What exactly you're after? Quote Link to comment Share on other sites More sharing options...
Rommeo Posted April 30, 2010 Author Share Posted April 30, 2010 Well... you can... But what's the point? What exactly you're after? what exactly you did not understand in that simple sentence ? lol i m just looking for a software that i can practice sql queries. Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 30, 2010 Share Posted April 30, 2010 You started asking about temporary tables. I assume you used word 'temporary' without knowing what it means in SQL. Anyway, the best way is to install local MySQL server and do your practice there. If you need GUI, you can use MySQL Query Browser from MySQL GUI Tools, or MySQL Workbench. Both available for free from MySQL site. There are also dozens of other software, that facilita working with MySQL. However, I know no free software that would match description you gave in your first post (assuming I understood it correctly). I know one corporate product, but their prices start from €100000 per deployment. Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted May 1, 2010 Share Posted May 1, 2010 I can see such a software for just 1 table, but when you need to make it work for more than 1 table, the task gets astronomically harder. Quote Link to comment Share on other sites More sharing options...
ack Posted May 1, 2010 Share Posted May 1, 2010 Two suggestions: 1. PHP & MYSQL For Dummies by Janet Valade (ISBN 0-470-09600-4[/b] This 'ol programmer found it very useful. B. If you use phpMyAdmin to manage your MYSQL databases online, it generates and displays query code on the resulting page every time you do something to your database tables. You can cut and paste these samples into a script and play with them. php and MYSQL requires patience to learn/understand when one is working by one's self. Some of us - who have been pounding out code at a semi-pro level for 30 years - still have trouble with figuring things out this way. The best way to learn is by hands-on trial and error coding. That, or taking a class at the local community college. When you come to a point where there seems to be no solution, you post here. By then, your vocabulary will be large enough that folks here will be able to understand and help you. I know this because I have been the newbie poster-boy on more forums than you can imagine! I hope that this helps! Quote Link to comment 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.