本文介绍了subselect sql查询不适用于mysql 4的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
以下sql查询在运行mysql 5的开发服务器上正常运行,但是当我在运行mysql 4的实时服务器上尝试运行它时,会抛出错误,有人可以帮助我说明如何使查询适应于mysql 4上运行吗?
The following sql query works fine on my development server running mysql 5, but when I try it on my live server running mysql 4 it throws an error, can anyone help show me how to adapt my query to run on mysql 4?
select * FROM Properties WHERE propertyid IN (select id from todelete)推荐答案
SELECT * FROM Properties RIGHT JOIN todelete ON (Properties.propertyid = todelete.id);
要从符合此条件的属性中删除所有行,请使用以下方法:
To delete all rows from Properties which match this condition use this:
DELETE Properties FROM Properties INNER JOIN todelete ON (Properties.propertyid = todelete.id);请参见 T-SQL:选择要通过联接删除的行
更多推荐
subselect sql查询不适用于mysql 4
发布评论