MySQL Performance: MySQL => What happen with MySQL 5?

Members

Help

Home

Home » Performance » MySQL » What happen with MySQL 5?

Show: Today's Messages :: Show Polls :: Message Navigator

What happen with MySQL 5? [message #112]

Fri, 25 August 2006 06:47

safari
Messages: 26
Registered: August 2006
Location: Vietnam

Junior Member

The following query can run on MySQL 4.1 but can not on MySQL 5.0.x:

SELECT c.*, rst.starttimename
FROM tblcourse c, tblcourse_category_extra ce
LEFT JOIN tblref_starttime rst ON rst.starttimeid = c.starttimeid
WHERE ce.courseid = c.courseid
ORDER BY c.approveddate DESC

Anyone can help to explain?

Thanks.

Report message to a moderator

Re: What happen with MySQL 5? [message #113 is a reply to message #112 ]

Fri, 25 August 2006 07:17

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

It would be helpful if you explain what do you mean by can't be run - is it way to slow or what is error message ?

I would guess you're mentioning

tblcourse table field in the LEFT JOIN clause which is forbidden in MySQL 5.0 - only joined tables can be refered in ON clause.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: What happen with MySQL 5? [message #115 is a reply to message #112 ]

Sat, 26 August 2006 02:17

vadimtk
Messages: 12
Registered: August 2006

Junior Member

safari,

try next query

SELECT c.*, rst.starttimename
FROM (tblcourse c, tblcourse_category_extra ce)
LEFT JOIN tblref_starttime rst ON rst.starttimeid = c.starttimeid
WHERE ce.courseid = c.courseid
ORDER BY c.approveddate DESC

Syntax was changed in 5.0.13

Report message to a moderator

Re: What happen with MySQL 5? [message #116 is a reply to message #115 ]

Sun, 27 August 2006 22:27

safari
Messages: 26
Registered: August 2006
Location: Vietnam

Junior Member

it works now. thanks vadim.

Report message to a moderator

Previous Topic:	Data size
Next Topic:	Optimizer Woes

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 20 03:08:37 EST 2008

Total time taken to generate the page: 0.01240 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.