[MYSQL] Syntaxe requête

Question

Bonjour,

J'aimerais faire un delete de ce genre:

DELETE FROM `client` WHERE `client`.`NOM` = 'DUPONT' AND WHERE `client`.`Prénom` = 'Jean';

Quel est la bonne syntaxe ? Merci.

arth · Answer

>Bah la syntaxe semble bonne quel est le réel problème?

RE4 · Answer

#1064 - 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 'WHERE `client`.`PrÃ©nom` = 'Jean' at line 1 

Voilà le problème.

arth · Answer

Essaie : 

DELETE * FROM `client` WHERE `client`.`NOM` = 'DUPONT' AND WHERE `client`.`Prénom` = 'Jean';

RE4 · Answer

Merci mais toujours une erreur.

arth · Answer

Laquelle cette fois la même?

RE4 · Answer

requête SQL:

DELETE * FROM `client` WHERE `client`.`NOM` = 'DUPONT' AND WHERE `client`.`Prénom` = 'Jean'

MySQL a répondu:Documentation
#1064 - 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 `client` WHERE `client`.`NOM` = 'DUPONT' AND WHERE `client`.`PrÃ©nom` = 'J' at line 1

RE4 · Answer

up

[MYSQL] Syntaxe requête

7 réponses

Discussions similaires

Newsletters