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
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
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