|
Posted by J.O. Aho on 12/03/05 13:03
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).
//Aho
Navigation:
[Reply to this message]
|