DELETE med USING og WHERE

Hvad er det der ikke virker ?

Nå ja, bruger du MySql 4+ ? De siger at "We have
multi-table DELETE statements" i version 4.

mysql> delete dataset_changes from dataset_changes, dataset where dataset_changes.dataset=dataset.id and dataset.category=1;
ERROR 1064: You have an error in your SQL syntax near 'dataset_changes from dataset_changes, dataset where dataset_changes.dataset=data' at line 1

delete from dataset_changes using dataset_changes, dataset where dataset_changes.dataset=dataset.id and dataset.category=1;
ERROR 1064: You have an error in your SQL syntax near 'using dataset_changes, dataset where dataset_changes.dataset=dataset.id and data' at line 1

Og hvilken MySql version?

3.23.39

Så kan du ikke bruge multitable deletes

:-( Damned..... Det er de da ikke ivrige efter at oplyse i dokumentationen.....

Lukker :-(