[Phpmyadmin-devel] RFE #1491

[Ashutosh Dhundhara]

Hi all,

I was looking into RFE #1491
<http://sourceforge.net/p/phpmyadmin/feature-requests/1491/> (Support
InnoDB for database Query by example). If I am not wrong, is the concept of
displaying the 'LEFT JOIN' is something like as discussed in the case below:

Lets say I have two tables:

CREATE TABLE `product` (
 `id` int(11) NOT NULL,
 `price` decimal(10,0) DEFAULT NULL,
 PRIMARY KEY (`id`)
)

CREATE TABLE `product_order` (
 `product_id` int(11) NOT NULL,
 `customer_id` int(11) NOT NULL,
 KEY `product_category` (`product_id`),
 KEY `customer_id` (`customer_id`),
 CONSTRAINT `product_order_ibfk_4` FOREIGN KEY (`product_id`) REFERENCES
`product` (`id`)
)

Now in QBE interface, when I will select `product_order`.`product_id` in
first column drop-down and `product`.`id` in second column drop-down, I
should get the following result:

FROM `db_name`.`product_order` LEFT JOIN `db_name`.`product` ON
`product_order`.`product_id`
= `product`.`id`

In general, 'LEFT JOIN' with foreign table and ON condition between master
column and foreign column. Am I getting it right?

-- 
Ashutosh Dhundhara
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140802/f29a8334/attachment.html>