MySQL Forums
Forum List  »  Newbie

Re: LEFTJOIN ???
Posted by: Peter Brawley
Date: December 12, 2017 05:21PM

In 5.6 and 5.7 both, it immediately returns ...

+-----------+-----------+---------------------------------------------+------------------------+------+------+------+--------+-------+--------+-----------+
| Man_Pt_Nr | Sup_Pt_Nr | Manufacturer                                | Description            | Qty  | Cost | RRP  | Weight | ETA   | Disti  | Condition |
+-----------+-----------+---------------------------------------------+------------------------+------+------+------+--------+-------+--------+-----------+
|  N074930A |  A151016  |  FUJIFILM                                   |  2GB COMPACTFLASH CARD |    5 | 7.13 | 8.99 |   0.01 |  NULL |  IM    |  NULL     |
|  5500-051 |  B090363  |  AXIS - SPARE PART CS MOUNTVARIFOCAL 3-8MM  |  0                     |   87 | 0.00 | 0.00 |   0.00 |  IM   |  NULL  | NULL      |
|  5500-061 |  B090462  |  AXIS - SPARE PART CS MOUNT VARIFOCAL 3-8MM |  0                     |    2 | 0.00 | 0.00 |   0.00 |  IM   |  NULL  | NULL      |
|  5500-071 |  B090466  |  AXIS - SPARE PART CS MOUNT VARIFOCAL       |  0                     | NULL | 0.00 | 0.00 |   0.00 |  IM   |  NULL  | NULL      |
+-----------+-----------+---------------------------------------------+------------------------+------+------+------+--------+-------+--------+-----------+

Something is amiss in your phpMyAdmin configuration or in your MySQL instance. Consider first trying the query in the mysql client. If you still get the problem, the problem is with mysql not phpMyAdmin, so run Check Table and Analyze Table on the two tables. If that doesn't fix it, try exporting the tabkes and importing them to a different db, then try again.

Why are you using MyISAM rather than InnoDB?

Options: ReplyQuote


Subject
Written By
Posted
December 12, 2017 11:41AM
December 12, 2017 12:04PM
December 12, 2017 03:39PM
Re: LEFTJOIN ???
December 12, 2017 05:21PM
December 13, 2017 03:04AM
December 13, 2017 03:29AM
December 13, 2017 08:38AM
December 13, 2017 08:45AM
December 13, 2017 10:34AM
December 15, 2017 09:57AM
December 16, 2017 04:44AM
December 19, 2017 10:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.