Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » What happen with MySQL 5?
What happen with MySQL 5? [message #112] Fri, 25 August 2006 06:47 Go to previous message
safari is currently offline 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
[Message index]

Read Message
Read Message
Read Message
Read Message
Previous Topic:Data size
Next Topic:Optimizer Woes
Goto Forum:

  

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

Current Time: Sun Jul 5 15:12:08 EDT 2009

Total time taken to generate the page: 0.63982 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.