subselect sql查询不适用于mysql 4 [英] subselect sql query doesn't work on 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！