Re: MySQL 4.0 => 5.0 - strange...
Alex Smith wrote:
> Strangely enough it works :)
> The query the way you provided seems ok. Does it
> mean I should patch whole project and all the
> queries enclosed? There are almost 4 thousand of
> them. I better kill myself! :) Where to download
> MySQL 4?.. ;)
Glad it worked! As an FYI, the style of SQL I used is ANSI standard, whereas the original style is called Theta style. Though it *should* produce the same results, I've seen examples of this (especially in older versions of MySQL server) where it can cause problems. In general, ANSI style I find to be a little more explicit, and thus a little more readable and less error-prone... You can find MySQL 4.1 and 5 downloads by clicking on the Downloads link above. You can find earlier 4.0 versions on the Downloads page; there is a link called "Older versions"
Cheers,
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com