Re: (OT) (OT) MySQL: delete from multiple tables

Oh, this is the error i get in mysql:

064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM hotfix, softwareinstalled WHERE data_set="temporary"' at

cheers, Steve

Comment on Re: (OT) (OT) MySQL: delete from multiple tables

Replies are listed 'Best First'.
Re^2: (OT) MySQL: delete from multiple tables by jhourcle (Prior) on Mar 14, 2005 at 16:23 UTC
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	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: (OT) MySQL: delete from multiple tables
by jhourcle (Prior) on Mar 14, 2005 at 16:23 UTC

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

[reply]
[d/l]
[select]