horribly basic DELETE problem

benbroad

I know this is basic but I am new to mySQL. I have 2 tables, both have urls held in a CHAR column. I need to delete all the entries in table 1 that have duplicate urls in table 2.

I tried:

DELETE FROM spQueue WHERE spQueue.url = spDone.url

but no joy it just tells me there is no such table as spDone, but I can see the damn thing.

Any help would be greatfully appreciated.

LordShryku

From http://www.mysql.com/doc/en/DELETE.html

The first multiple-table delete format is supported starting from MySQL 4.0.0. The second multiple-table delete format is supported starting from MySQL 4.0.2.

The .* after the table names is there just to be compatible with Access:

DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id

or

DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id

In the above case we delete matching rows only from tables t1 and t2.

benbroad

Yeah, I had read that but I am obviously having a dim day as I still dont get it.

I tried:

DELETE FROM spQueue USING spQueue, spDone WHERE spQueue.url=spDone.url

which as far as I can tell is the second syntax from your quote but I just get a syntax error.

LordShryku

What version of MySQL do you have?

benbroad

Ah. It says Client API Module: 3.23.58 - I didn't realise it was that old.