mysql 5.7.6
I want to ask. Recently i install mysql 5.7.6. but there is a problem with my sql. Before this i use mysql 5.5 no problem
My sql problem
SELECT `etutor_forummain`.`forumID` AS `fID`, `etutor_forummain`.`title`, `etutor_forummain`.`catid`, `etutor_forummain`.`blockcontentid`, (SELECT COUNT(*) FROM `etutor_content` WHERE (forumID = fID)) AS `totalthread` FROM `etutor_forummain`
I have to change the sql to this sql
SELECT `etutor_forummain`.`forumID` AS `fID`, `etutor_forummain`.`title`, `etutor_forummain`.`catid`, `etutor_forummain`.`blockcontentid`, (SELECT COUNT(*) FROM `etutor_content` WHERE (forumID = etutor_forummain.forumID)) AS `totalthread` FROM `etutor_forummain`
Why this thing happen?
Subject
Written By
Posted
mysql 5.7.6
December 03, 2015 08:53PM
December 03, 2015 09:04PM
December 03, 2015 09:08PM
December 04, 2015 12:37PM
December 21, 2015 08:08PM
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.