Page 1 of 1

BAD QUERY??

Posted: Tue Sep 24, 2002 10:52 am
by gastonlm
I'm trying to delete some data from a table, but I can't. I tried to ways but it didn'y work. What's wrong with them??

Code: Select all

DELETE FROM objetotarifaparticularidioma.* USING objetotarifaparticularidioma, objetotarifaparticular, objetotarifa, objeto WHERE objetotarifaparticularidioma.objetotarifaparticularID = objetotarifaparticular.ID AND objetotarifaparticular.objetotarifaID = objetotarifa.ID AND objetotarifa.objetoID = objeto.ID AND objeto.objetoinfoID = 1

Code: Select all

DELETE FROM objetotarifaparticularidioma.* USING objetotarifaparticularidioma, objetotarifaparticular, objetotarifa, objeto WHERE objetotarifaparticularidioma.objetotarifaparticularID = objetotarifaparticular.ID AND objetotarifaparticular.objetotarifaID = objetotarifa.ID AND objetotarifa.objetoID = objeto.ID AND objeto.objetoinfoID = 1

Posted: Tue Sep 24, 2002 1:12 pm
by twigletmac
Which database are you using?

Are you getting any error messages when you try and run the query?

Mac

Posted: Tue Sep 24, 2002 1:39 pm
by gastonlm
I'm executting it from the phpmyadmin. I have the following errors:
Code 1.
MySQL said: You have an error in your SQL syntax near '* USING objetotarifaparticularidioma, objetotarifaparticular, objetotarifa, obje' at line 1

Code 2. I made a mistake. The code is:
DELETE objetotarifaparticularidioma FROM objetotarifaparticularidioma, objetotarifaparticular, objetotarifa, objeto WHERE objetotarifaparticularidioma.objetotarifaparticularID = objetotarifaparticular.ID AND objetotarifaparticular.objetotarifaID = objetotarifa.ID AND objetotarifa.objetoID = objeto.ID AND objeto.objetoinfoID = 1

and the error is

MySQL said: You have an error in your SQL syntax near 'objetotarifaparticularidioma FROM objetotarifaparticularidioma, objetotarifapart' at line 1