Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Mysql version issue
December 3, 2005, 10:00 am
rate this thread
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
DELETE FROM contracts WHERE ProjectKey NOT IN
(SELECT ProjectKey FROM contractsnew2)
#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.
Re: Mysql version issue
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).