Posted by John on 12/03/05 13:46

On Sat, 03 Dec 2005 12:03:12 +0100, "J.O. Aho" <user@example.net>
wrote:

>John wrote:
>> 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)
>
>No subqueries support in 4.0.x or earlier versions.
>
>You will either have to first fetch the "SELECT ProjectKey FROM contractsnew2"
>and then add all that to the IN statement in the DELETE query, or just update
>the MySQL (this requires you make a backup of all the databases, uninstall the
>4.0.x and then install 4.1.x and then restore the backup).

Thanks for that and to Simon.
I will attempt to get our server upgraded.

--
John

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

[Reply to this message]