List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:January 23 2007 3:50am
Subject:Re: MYSQL reporting an error with subquery query
View as plain text  
In the last episode (Jan 23), A Blossom of Paradise said:
> SELECT version()
> 
> reveals...
> 
> 4.0.24-nt-max-log
> 
> I have looked at the following query a hundred times, and cannot find
> how MYSQL can report a syntax error to me.

4.0 does not support subqueries.  You will need to upgrade to at least
4.1, preferably 5.0.  If you are stuck with 4.0, take a look at
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html for
hints on rewriting the query using joins or temporary tables.

-- 
	Dan Nelson
	dnelson@stripped
Thread
MYSQL reporting an error with subquery queryA Blossom of Paradise23 Jan
  • Re: MYSQL reporting an error with subquery queryDan Nelson23 Jan
  • Re: MYSQL reporting an error with subquery queryViSolve DB Team29 Jan