in reply to Re: (OT) (OT) MySQL: delete from multiple tables
in thread (OT) MySQL: delete from multiple tables

That's a different problem. Well, there's still the problem with the use of double quotes instead of single quotes, but I'm guessing you also tried specify the fields as *. Delete does not take a field list, as it removes all fields. If you want to use the multi-table delete (which I still don't recommend), you should use:

DELETE FROM hotfix, softwareinstalled WHERE data_set='temporary';

and not

DELETE * FROM hotfix, softwareinstalled WHERE data_set="temporary";

Update: double quotes aren't a problem in mySQL, as per Jasper