Posted by Simon on 12/03/05 12:01

I am not 100% sure but I feel that 4.0.20 doesn't support subqueries.


"John" <ybghbjdo@dfsrtfu> wrote in message
news:q6q2p1h6eepehehoe28bko9evk8n5i369k@4ax.com...
> A colleague of mine is having problems on our system.
>
> He is running a mysql command on his local setup which runs 4.1.7 -nt
> and which works fine.
>
> However this fails when uploaded to the server which is running
> 4.0.20. The error and the command is
>
> Database sovaproj - Table contractsnew2 running on db
> Error
> SQL-query :
>
> DELETE FROM contracts WHERE ProjectKey NOT IN
> (SELECT ProjectKey FROM contractsnew2)
>
> MySQL said:
>
> #1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT ProjectKey
> FROM contractsnew2 )' at line 1
>
> A search of google and the mysql manual shows that there are
> differences in the versions which is causing problems for some but I
> couldn't see how in this case.
>
> Any thoughts or ideas greatly appreciated.
>
> Thanks
>
> --
> John
>

• Next in forum: forward named page to php query
• Prev in forum: Mysql version issue
• Thread view: Re: Mysql version issue

[Reply to this message]