BAD QUERY??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gastonlm
Forum Commoner
Posts: 26
Joined: Tue May 07, 2002 10:19 am
Location: Buenos Aires, Argentina
Contact:

BAD QUERY??

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Which database are you using?

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

Mac
gastonlm
Forum Commoner
Posts: 26
Joined: Tue May 07, 2002 10:19 am
Location: Buenos Aires, Argentina
Contact:

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