Mysql Query with and without join

Asked Oct 14 '14 at 08:38

Active Oct 14 '14 at 09:08

Viewed 42 times

CREATE TABLE IF NOT EXISTS `product` (
  `maker` varchar(10) NOT NULL,
  `model` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`model`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

and

    CREATE TABLE IF NOT EXISTS `laptop` (
  `code` int(11) NOT NULL,
  `model` varchar(50) NOT NULL,
  `speed` smallint(6) NOT NULL,
  `ram` smallint(6) NOT NULL,
  `hd` double NOT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `screen` tinyint(4) NOT NULL,
  PRIMARY KEY (`code`),
  KEY `FK_Laptop_product` (`model`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

These are the two tables, now I have two queries-

SELECT * FROM `product` inner join laptop on product.model = laptop.model

and

select * from product, laptop where product.model = laptop.model

Both the queries gives same result, So is there any difference in two approaches. Please provide few good examples

edited Oct 14 '14 at 09:08

Param Kumar

asked Oct 14 '14 at 08:38

Anjil Panchal

THis is about inner join compared to cross join, http://stackoverflow.com/questions/670980/performance-of-inner-join-compared-to-cross-join – NMK Oct 14 '14 at 08:41
That's actually the same query, just using two different notations! – ToBe Oct 14 '14 at 08:41
No comment. Both of them are the same. – Hendry Tanaka Oct 14 '14 at 08:44
Search on Google for implicit v/s explicit join. Performance wise even they should be almost same. While implicit joins are discouraged. – SMA Oct 14 '14 at 08:44
@almasshaikh From MySQL's POV, they are identical. The EXPLAIN (EXTENDED) would prove this. – Strawberry Oct 14 '14 at 08:46
Sorry for duplicate question. – Anjil Panchal Oct 14 '14 at 10:49

Mysql Query with and without join

0 Answers0