Le 2011-04-04 11:14, Dhruv Baldawa a écrit :
*Personal Details*
*Name:*Dhruv Baldawa *Email:*dhruvbaldawa@gmail.com *Skype ID or GTalk:*dhruvbaldawa@gmail.com *IRC nick:*dhruvbaldawa *Phone number:* +(91)-9323321233 *School Name:* Thakur College of Engineering and Technology, University of Mumbai *Years completed:*Third Year Computer Engineering *Python Experience Level:*Intermediate
*Project Description*
*Describe your idea in detail:*SQL is a generic language and is the most common language used for database querying. But, the problem with SQL is, when a new user fires a SQL query, he needs to know 2 things :
- He needs to all the relations in the schema, and how are they related,
and how are they linked using which attributes. 2. When a user needs to fire similar queries (similar means queries with almost same entities), in such a case all the JOIN statements or linking conditions have to be rewritten.
So, here I propose a tool, which comprises of a metadata and syntax generator, algorithm and query helper, which can help user create a specialized syntax for querying the database in a simple and efficient manner, ignoring all the linking between the various tables.
Hi, in phpMyAdmin 3.3, there is a multi-table query generator (click on a db name, then Query). In version 3.4 this has been augmented with a visual builder.
Did you notice these features in phpMyAdmin?