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 :
1. 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?
--
Marc Delisle
http://infomarc.info