ANKIT GUPTA wrote:
Hi,
will update my proposal.
for the sub query option with "where" we still don't have any visual builder............... one way which i thought was having a link ->"build query" which will open a complete new query building window . but this will make thing complex and i don't want to show a new window. what you think??
Making this nestable might add a natural force to write clean re-usable code. But the risk of making this to complex seems very serious.
also i have started looking through the code for phpMyadmin , can u suggest me what all sections in present code are related and can be used for visual query building this will be of great help .
Besides the Designer I'd look at the relational code for innodb and the internally stored relations for myisam. And obviously the Query tab.