subselect sql query doesn't work on mysql 4

Question

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)

first run `SELECT id FROM todelete` and see the response – xkeshav Mar 04 '11 at 13:05 — xkeshav, Mar 04 '11 at 13:05

score 3 · Answer 1 · answered Mar 04 '11 at 13:04

3

Subqueries are not supported in versions lower than Mysql 4.1.

http://dev.mysql.com/doc/refman/4.1/en/subqueries.html

answered Mar 04 '11 at 13:04

Blake Pettersson

8,927
3
27
36

score 1 · Accepted Answer · edited May 23 '17 at 11:46

1

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);

See T-SQL: Selecting rows to delete via joins

edited May 23 '17 at 11:46

Community

1
1

answered Mar 04 '11 at 13:04

powtac

40,542
28
115
170

Thats great but I want to delete the results of this query from Properties table and I can't do that with the above query – Simon Foster Mar 04 '11 at 14:03

subselect sql query doesn't work on mysql 4

2 Answers2

Linked