Requête Delete : Supprimer des enregistrements sur plusieurs tables

Messages postés
133
Date d'inscription
mercredi 11 octobre 2006
Statut
Membre
Dernière intervention
21 octobre 2019
- - Dernière réponse : traderpierre
Messages postés
133
Date d'inscription
mercredi 11 octobre 2006
Statut
Membre
Dernière intervention
21 octobre 2019
- 4 juil. 2019 à 22:31
Bonjour,
J'ai plusieurs tables non liées entre elles qui possèdent une colonne id_lang,
je souhaite supprimer des id de langues dans ces tables :
Voici ma requête qui ne fonctionne pas :
DELETE `ps_advice_lang`.`id_Lang` ,
`ps_attachment_lang`.`id_Lang` ,
`ps_attribute_group_lang`.`id_Lang` ,
`ps_attribute_lang`.`id_Lang` ,
`ps_badge_lang`.`id_Lang` ,
`ps_carrier_lang`.`id_Lang` ,
`ps_cart_rule_lang`.`id_Lang` ,
`ps_category_lang`.`id_Lang` ,
`ps_cms_category_lang`.`id_Lang` ,
`ps_cms_lang`.`id_Lang` ,
`ps_cms_role_lang`.`id_Lang` ,
`ps_configuration_kpi_lang`.`id_Lang` ,
`ps_configuration_lang`.`id_Lang` ,
`ps_contact_lang`.`id_Lang` ,
`ps_country_lang`.`id_Lang` ,
`ps_customization_field_lang`.`id_Lang` ,
`ps_feature_lang`.`id_Lang` ,
`ps_feature_value_lang`.`id_Lang` ,
`ps_gender_lang`.`id_Lang` ,
`ps_group_lang`.`id_Lang` ,
`ps_homeslider_slides_lang`.`id_Lang` ,
`ps_image_lang`.`id_Lang` ,
`ps_info_lang`.`id_Lang` ,
`ps_lang`.`id_Lang` ,
`ps_lang_shop`.`id_Lang` ,
`ps_layered_indexable_attribute_group_lang_value`.`id_Lang` ,
`ps_layered_indexable_attribute_lang_value`.`id_Lang` ,
`ps_layered_indexable_feature_lang_value`.`id_Lang` ,
`ps_layered_indexable_feature_value_lang_value`.`id_Lang` ,
`ps_linksmenutop_lang`.`id_Lang` ,
`ps_link_block_lang`.`id_Lang` ,
`ps_manufacturer_lang`.`id_Lang` ,
`ps_meta_lang`.`id_Lang` ,
`ps_multihtmlblockbadeaude_lang`.`id_Lang` ,
`ps_multihtmlblockbadeaues_lang`.`id_Lang` ,
`ps_multihtmlblockbadeauit_lang`.`id_Lang` ,
`ps_multihtmlblockbadeauuk_lang`.`id_Lang` ,
`ps_multihtmlblockbandeaude_lang`.`id_Lang` ,
`ps_multihtmlblockbandeaues_lang`.`id_Lang` ,
`ps_multihtmlblockbandeaufr_lang`.`id_Lang` ,
`ps_multihtmlblockbandeauit_lang`.`id_Lang` ,
`ps_multihtmlblockbandeauuk_lang`.`id_Lang` ,
`ps_order_message_lang`.`id_Lang` ,
`ps_order_return_state_lang`.`id_Lang` ,
`ps_order_state_lang`.`id_Lang` ,
`ps_product_lang`.`id_Lang` ,
`ps_profile_lang`.`id_Lang` ,
`ps_quick_access_lang`.`id_Lang` ,
`ps_reassurance_lang`.`id_Lang` ,
`ps_risk_lang`.`id_Lang`

FROM `ps_advice_lang`,
`ps_attachment_lang`,
`ps_attribute_group_lang`,
`ps_attribute_lang`,
`ps_badge_lang`,
`ps_carrier_lang`,
`ps_cart_rule_lang`,
`ps_category_lang`,
`ps_cms_category_lang`,
`ps_cms_lang`,
`ps_cms_role_lang`,
`ps_configuration_kpi_lang`,
`ps_configuration_lang`,
`ps_contact_lang`,
`ps_country_lang`,
`ps_customization_field_lang`,
`ps_feature_lang`,
`ps_feature_value_lang`,
`ps_gender_lang`,
`ps_group_lang`,
`ps_homeslider_slides_lang`,
`ps_image_lang`,
`ps_info_lang`,
`ps_lang`,
`ps_lang_shop`,
`ps_layered_indexable_attribute_group_lang_value`,
`ps_layered_indexable_attribute_lang_value`,
`ps_layered_indexable_feature_lang_value`,
`ps_layered_indexable_feature_value_lang_value`,
`ps_linksmenutop_lang`,
`ps_link_block_lang`,
`ps_manufacturer_lang`,
`ps_meta_lang`,
`ps_multihtmlblockbadeaude_lang`,
`ps_multihtmlblockbadeaues_lang`,
`ps_multihtmlblockbadeauit_lang`,
`ps_multihtmlblockbadeauuk_lang`,
`ps_multihtmlblockbandeaude_lang`,
`ps_multihtmlblockbandeaues_lang`,
`ps_multihtmlblockbandeaufr_lang`,
`ps_multihtmlblockbandeauit_lang`,
`ps_multihtmlblockbandeauuk_lang`,
`ps_order_message_lang`,
`ps_order_return_state_lang`,
`ps_order_state_lang`,
`ps_product_lang`,
`ps_profile_lang`,
`ps_quick_access_lang`,
`ps_reassurance_lang`,
`ps_risk_lang`

WHERE (((`ps_advice_lang`.`id_lang`)=8) AND
((`ps_attachment_lang`.`id_lang`)=8) AND
((`ps_attribute_group_lang`.`id_lang`)=8) AND
((`ps_attribute_lang`.`id_lang`)=8) AND
((`ps_badge_lang`.`id_lang`)=8) AND
((`ps_carrier_lang`.`id_lang`)=8) AND
((`ps_cart_rule_lang`.`id_lang`)=8) AND
((`ps_category_lang`.`id_lang`)=8) AND
((`ps_cms_category_lang`.`id_lang`)=8) AND
((`ps_cms_lang`.`id_lang`)=8) AND
((`ps_cms_role_lang`.`id_lang`)=8) AND
((`ps_configuration_kpi_lang`.`id_lang`)=8) AND
((`ps_configuration_lang`.`id_lang`)=8) AND
((`ps_contact_lang`.`id_lang`)=8) AND
((`ps_country_lang`.`id_lang`)=8) AND
((`ps_customization_field_lang`.`id_lang`)=8) AND
((`ps_feature_lang`.`id_lang`)=8) AND
((`ps_feature_value_lang`.`id_lang`)=8) AND
((`ps_gender_lang`.`id_lang`)=8) AND
((`ps_group_lang`.`id_lang`)=8) AND
((`ps_homeslider_slides_lang`.`id_lang`)=8) AND
((`ps_image_lang`.`id_lang`)=8) AND
((`ps_info_lang`.`id_lang`)=8) AND
((`ps_lang`.`id_lang`)=8) AND
((`ps_lang_shop`.`id_lang`)=8) AND
((`ps_layered_indexable_attribute_group_lang_value`.`id_lang`)=8) AND
((`ps_layered_indexable_attribute_lang_value`.`id_lang`)=8) AND
((`ps_layered_indexable_feature_lang_value`.`id_lang`)=8) AND
((`ps_layered_indexable_feature_value_lang_value`.`id_lang`)=8) AND
((`ps_linksmenutop_lang`.`id_lang`)=8) AND
((`ps_link_block_lang`.`id_lang`)=8) AND
((`ps_manufacturer_lang`.`id_lang`)=8) AND
((`ps_meta_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeaude_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeaues_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeauit_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeauuk_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeaude_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeaues_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeaufr_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeauit_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeauuk_lang`.`id_lang`)=8) AND
((`ps_order_message_lang`.`id_lang`)=8) AND
((`ps_order_return_state_lang`.`id_lang`)=8) AND
((`ps_order_state_lang`.`id_lang`)=8) AND
((`ps_product_lang`.`id_lang`)=8) AND
((`ps_profile_lang`.`id_lang`)=8) AND
((`ps_quick_access_lang`.`id_lang`)=8) AND
((`ps_reassurance_lang`.`id_lang`)=8) AND
((`ps_risk_lang`.`id_lang`)=8));

______________________________________

MySql me renvoi :
Erreur

Requête SQL :

DELETE `ps_advice_lang`.`id_Lang` ,
`ps_attachment_lang`.`id_Lang` ,
`ps_attribute_group_lang`.`id_Lang` ,
`ps_attribute_lang`.`id_Lang` ,
`ps_badge_lang`.`id_Lang` ,
`ps_carrier_lang`.`id_Lang` ,
`ps_cart_rule_lang`.`id_Lang` ,
`ps_category_lang`.`id_Lang` ,
`ps_cms_category_lang`.`id_Lang` ,
`ps_cms_lang`.`id_Lang` ,
`ps_cms_role_lang`.`id_Lang` ,
`ps_configuration_kpi_lang`.`id_Lang` ,
`ps_configuration_lang`.`id_Lang` ,
`ps_contact_lang`.`id_Lang` ,
`ps_country_lang`.`id_Lang` ,
`ps_customization_field_lang`.`id_Lang` ,
`ps_feature_lang`.`id_Lang` ,
`ps_feature_value_lang`.`id_Lang` ,
`ps_gender_lang`.`id_Lang` ,
`ps_group_lang`.`id_Lang` ,
`ps_homeslider_slides_lang`.`id_Lang` ,
`ps_image_lang`.`id_Lang` ,
`ps_info_lang`.`id_Lang` ,
`ps_lang`.`id_Lang` ,
`ps_lang_shop`.`id_Lang` ,
`ps_layered_indexable_attribute_group_lang_value`.`id_Lang` ,
`ps_layered_indexable_attribute_lang_value`.`id_Lang` ,
`ps_layered_indexable_feature_l[...]

Erreur

Requête SQL :

DELETE `ps_advice_lang`.`id_Lang` ,
`ps_attachment_lang`.`id_Lang` ,
`ps_attribute_group_lang`.`id_Lang` ,
`ps_attribute_lang`.`id_Lang` ,
`ps_badge_lang`.`id_Lang` ,
`ps_carrier_lang`.`id_Lang` ,
`ps_cart_rule_lang`.`id_Lang` ,
`ps_category_lang`.`id_Lang` ,
`ps_cms_category_lang`.`id_Lang` ,
`ps_cms_lang`.`id_Lang` ,
`ps_cms_role_lang`.`id_Lang` ,
`ps_configuration_kpi_lang`.`id_Lang` ,
`ps_configuration_lang`.`id_Lang` ,
`ps_contact_lang`.`id_Lang` ,
`ps_country_lang`.`id_Lang` ,
`ps_customization_field_lang`.`id_Lang` ,
`ps_feature_lang`.`id_Lang` ,
`ps_feature_value_lang`.`id_Lang` ,
`ps_gender_lang`.`id_Lang` ,
`ps_group_lang`.`id_Lang` ,
`ps_homeslider_slides_lang`.`id_Lang` ,
`ps_image_lang`.`id_Lang` ,
`ps_info_lang`.`id_Lang` ,
`ps_lang`.`id_Lang` ,
`ps_lang_shop`.`id_Lang` ,
`ps_layered_indexable_attribute_group_lang_value`.`id_Lang` ,
`ps_layered_indexable_attribute_lang_value`.`id_Lang` ,
`ps_layered_indexable_feature_l[...]

MySQL me retourne :
DELETE `ps_advice_lang`.`id_Lang` ,
`ps_attachment_lang`.`id_Lang` ,
`ps_attribute_group_lang`.`id_Lang` ,
`ps_attribute_lang`.`id_Lang` ,
`ps_badge_lang`.`id_Lang` ,
`ps_carrier_lang`.`id_Lang` ,
`ps_cart_rule_lang`.`id_Lang` ,
`ps_category_lang`.`id_Lang` ,
`ps_cms_category_lang`.`id_Lang` ,
`ps_cms_lang`.`id_Lang` ,
MySQL a répondu : Documentation
#1109 - Table inconnue 'id_lang' dans MULTI DELETE

Pouvez-vous me conseiller pour solutionner ce problème ???
Merci par avance
Afficher la suite 

2 réponses

Messages postés
26550
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
21 octobre 2019
1839
0
Merci
Pour poster du code sur le forum, merci de le faire en utilisant LES BALISES DE CODE (et en y précisant le langage afin d'avoir la coloration syntaxique)
Explications disponibles ici : https://codes-sources.commentcamarche.net/faq/11288-les-balises-de-code
Commenter la réponse de jordane45
Messages postés
27008
Date d'inscription
mercredi 2 mai 2007
Statut
Modérateur
Dernière intervention
21 octobre 2019
5578
0
Merci
Rebonjour,

Ce que l'on delete ce sont des lignes, pas des colonnes, donc l'instruction ne commence pas par une liste de champs.

Et pourquoi vouloir toujours faire en une seule requete, très complexe.

PS : et la balise code de ccm !

traderpierre
Messages postés
133
Date d'inscription
mercredi 11 octobre 2006
Statut
Membre
Dernière intervention
21 octobre 2019
-
C'est bien des lignes définies dans la condition WHERE faisant référence à un id défini dans la colonne id_lang de chaque tables :
WHERE (((`ps_advice_lang`.`id_lang`)=8) AND
((`ps_attachment_lang`.`id_lang`)=8) AND
((`ps_attribute_group_lang`.`id_lang`)=8) AND
((`ps_attribute_lang`.`id_lang`)=8) AND
((`ps_badge_lang`.`id_lang`)=8) AND
((`ps_carrier_lang`.`id_lang`)=8) AND
((`ps_cart_rule_lang`.`id_lang`)=8) AND
((`ps_category_lang`.`id_lang`)=8) AND
((`ps_cms_category_lang`.`id_lang`)=8) AND
((`ps_cms_lang`.`id_lang`)=8) AND
((`ps_cms_role_lang`.`id_lang`)=8) AND
((`ps_configuration_kpi_lang`.`id_lang`)=8) AND
((`ps_configuration_lang`.`id_lang`)=8) AND
((`ps_contact_lang`.`id_lang`)=8) AND
((`ps_country_lang`.`id_lang`)=8) AND
((`ps_customization_field_lang`.`id_lang`)=8) AND
((`ps_feature_lang`.`id_lang`)=8) AND
((`ps_feature_value_lang`.`id_lang`)=8) AND
((`ps_gender_lang`.`id_lang`)=8) AND
((`ps_group_lang`.`id_lang`)=8) AND
((`ps_homeslider_slides_lang`.`id_lang`)=8) AND
((`ps_image_lang`.`id_lang`)=8) AND
((`ps_info_lang`.`id_lang`)=8) AND
((`ps_lang`.`id_lang`)=8) AND
((`ps_lang_shop`.`id_lang`)=8) AND
((`ps_layered_indexable_attribute_group_lang_value`.`id_lang`)=8) AND
((`ps_layered_indexable_attribute_lang_value`.`id_lang`)=8) AND
((`ps_layered_indexable_feature_lang_value`.`id_lang`)=8) AND
((`ps_layered_indexable_feature_value_lang_value`.`id_lang`)=8) AND
((`ps_linksmenutop_lang`.`id_lang`)=8) AND
((`ps_link_block_lang`.`id_lang`)=8) AND
((`ps_manufacturer_lang`.`id_lang`)=8) AND
((`ps_meta_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeaude_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeaues_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeauit_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbadeauuk_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeaude_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeaues_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeaufr_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeauit_lang`.`id_lang`)=8) AND
((`ps_multihtmlblockbandeauuk_lang`.`id_lang`)=8) AND
((`ps_order_message_lang`.`id_lang`)=8) AND
((`ps_order_return_state_lang`.`id_lang`)=8) AND
((`ps_order_state_lang`.`id_lang`)=8) AND
((`ps_product_lang`.`id_lang`)=8) AND
((`ps_profile_lang`.`id_lang`)=8) AND
((`ps_quick_access_lang`.`id_lang`)=8) AND
((`ps_reassurance_lang`.`id_lang`)=8) AND
((`ps_risk_lang`.`id_lang`)=8));
traderpierre
Messages postés
133
Date d'inscription
mercredi 11 octobre 2006
Statut
Membre
Dernière intervention
21 octobre 2019
-
Voici la requête complète et à la fin la réponse de MySql

DELETE `ps_advice_lang`.`id_lang` , 
`ps_attachment_lang`.`id_lang` , 
`ps_attribute_group_lang`.`id_lang` , 
`ps_attribute_lang`.`id_lang` , 
`ps_badge_lang`.`id_lang` , 
`ps_carrier_lang`.`id_lang` , 
`ps_cart_rule_lang`.`id_lang` , 
`ps_category_lang`.`id_lang` , 
`ps_cms_category_lang`.`id_lang` , 
`ps_cms_lang`.`id_lang` , 
`ps_cms_role_lang`.`id_lang` , 
`ps_configuration_kpi_lang`.`id_lang` , 
`ps_configuration_lang`.`id_lang` , 
`ps_contact_lang`.`id_lang` , 
`ps_country_lang`.`id_lang` , 
`ps_customization_field_lang`.`id_lang` , 
`ps_feature_lang`.`id_lang` , 
`ps_feature_value_lang`.`id_lang` , 
`ps_gender_lang`.`id_lang` , 
`ps_group_lang`.`id_lang` , 
`ps_homeslider_slides_lang`.`id_lang` , 
`ps_image_lang`.`id_lang` , 
`ps_info_lang`.`id_lang` , 
`ps_lang`.`id_lang` , 
`ps_lang_shop`.`id_lang` , 
`ps_layered_indexable_attribute_group_lang_value`.`id_lang` , 
`ps_layered_indexable_attribute_lang_value`.`id_lang` , 
`ps_layered_indexable_feature_lang_value`.`id_lang` , 
`ps_layered_indexable_feature_value_lang_value`.`id_lang` , 
`ps_linksmenutop_lang`.`id_lang` , 
`ps_link_block_lang`.`id_lang` , 
`ps_manufacturer_lang`.`id_lang` , 
`ps_meta_lang`.`id_lang` , 
`ps_multihtmlblockbadeaude_lang`.`id_lang` , 
`ps_multihtmlblockbadeaues_lang`.`id_lang` , 
`ps_multihtmlblockbadeauit_lang`.`id_lang` , 
`ps_multihtmlblockbadeauuk_lang`.`id_lang` , 
`ps_multihtmlblockbandeaude_lang`.`id_lang` , 
`ps_multihtmlblockbandeaues_lang`.`id_lang` , 
`ps_multihtmlblockbandeaufr_lang`.`id_lang` , 
`ps_multihtmlblockbandeauit_lang`.`id_lang` , 
`ps_multihtmlblockbandeauuk_lang`.`id_lang` , 
`ps_order_message_lang`.`id_lang` , 
`ps_order_return_state_lang`.`id_lang` , 
`ps_order_state_lang`.`id_lang` , 
`ps_product_lang`.`id_lang` , 
`ps_profile_lang`.`id_lang` , 
`ps_quick_access_lang`.`id_lang` , 
`ps_reassurance_lang`.`id_lang` , 
`ps_risk_lang`.`id_lang` 
FROM`ps_advice_lang`, 
`ps_attachment_lang`, 
`ps_attribute_group_lang`, 
`ps_attribute_lang`, 
`ps_badge_lang`, 
`ps_carrier_lang`, 
`ps_cart_rule_lang`, 
`ps_category_lang`, 
`ps_cms_category_lang`, 
`ps_cms_lang`, 
`ps_cms_role_lang`, 
`ps_configuration_kpi_lang`, 
`ps_configuration_lang`, 
`ps_contact_lang`, 
`ps_country_lang`, 
`ps_customization_field_lang`, 
`ps_feature_lang`, 
`ps_feature_value_lang`, 
`ps_gender_lang`, 
`ps_group_lang`, 
`ps_homeslider_slides_lang`, 
`ps_image_lang`, 
`ps_info_lang`, 
`ps_lang`, 
`ps_lang_shop`, 
`ps_layered_indexable_attribute_group_lang_value`, 
`ps_layered_indexable_attribute_lang_value`, 
`ps_layered_indexable_feature_lang_value`, 
`ps_layered_indexable_feature_value_lang_value`, 
`ps_linksmenutop_lang`, 
`ps_link_block_lang`, 
`ps_manufacturer_lang`, 
`ps_meta_lang`, 
`ps_multihtmlblockbadeaude_lang`, 
`ps_multihtmlblockbadeaues_lang`, 
`ps_multihtmlblockbadeauit_lang`, 
`ps_multihtmlblockbadeauuk_lang`, 
`ps_multihtmlblockbandeaude_lang`, 
`ps_multihtmlblockbandeaues_lang`, 
`ps_multihtmlblockbandeaufr_lang`, 
`ps_multihtmlblockbandeauit_lang`, 
`ps_multihtmlblockbandeauuk_lang`, 
`ps_order_message_lang`, 
`ps_order_return_state_lang`, 
`ps_order_state_lang`, 
`ps_product_lang`, 
`ps_profile_lang`, 
`ps_quick_access_lang`, 
`ps_reassurance_lang`, 
`ps_risk_lang` 
WHERE (((`ps_advice_lang`.`id_lang`)=8) AND 
((`ps_attachment_lang`.`id_lang`)=8) AND 
((`ps_attribute_group_lang`.`id_lang`)=8) AND 
((`ps_attribute_lang`.`id_lang`)=8) AND 
((`ps_badge_lang`.`id_lang`)=8) AND 
((`ps_carrier_lang`.`id_lang`)=8) AND 
((`ps_cart_rule_lang`.`id_lang`)=8) AND 
((`ps_category_lang`.`id_lang`)=8) AND 
((`ps_cms_category_lang`.`id_lang`)=8) AND 
((`ps_cms_lang`.`id_lang`)=8) AND 
((`ps_cms_role_lang`.`id_lang`)=8) AND 
((`ps_configuration_kpi_lang`.`id_lang`)=8) AND 
((`ps_configuration_lang`.`id_lang`)=8) AND 
((`ps_contact_lang`.`id_lang`)=8) AND 
((`ps_country_lang`.`id_lang`)=8) AND 
((`ps_customization_field_lang`.`id_lang`)=8) AND 
((`ps_feature_lang`.`id_lang`)=8) AND 
((`ps_feature_value_lang`.`id_lang`)=8) AND 
((`ps_gender_lang`.`id_lang`)=8) AND 
((`ps_group_lang`.`id_lang`)=8) AND 
((`ps_homeslider_slides_lang`.`id_lang`)=8) AND 
((`ps_image_lang`.`id_lang`)=8) AND 
((`ps_info_lang`.`id_lang`)=8) AND 
((`ps_lang`.`id_lang`)=8) AND 
((`ps_lang_shop`.`id_lang`)=8) AND 
((`ps_layered_indexable_attribute_group_lang_value`.`id_lang`)=8) AND 
((`ps_layered_indexable_attribute_lang_value`.`id_lang`)=8) AND 
((`ps_layered_indexable_feature_lang_value`.`id_lang`)=8) AND 
((`ps_layered_indexable_feature_value_lang_value`.`id_lang`)=8) AND 
((`ps_linksmenutop_lang`.`id_lang`)=8) AND 
((`ps_link_block_lang`.`id_lang`)=8) AND 
((`ps_manufacturer_lang`.`id_lang`)=8) AND 
((`ps_meta_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbadeaude_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbadeaues_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbadeauit_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbadeauuk_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbandeaude_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbandeaues_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbandeaufr_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbandeauit_lang`.`id_lang`)=8) AND 
((`ps_multihtmlblockbandeauuk_lang`.`id_lang`)=8) AND 
((`ps_order_message_lang`.`id_lang`)=8) AND 
((`ps_order_return_state_lang`.`id_lang`)=8) AND 
((`ps_order_state_lang`.`id_lang`)=8) AND 
((`ps_product_lang`.`id_lang`)=8) AND 
((`ps_profile_lang`.`id_lang`)=8) AND 
((`ps_quick_access_lang`.`id_lang`)=8) AND 
((`ps_reassurance_lang`.`id_lang`)=8) AND 
((`ps_risk_lang`.`id_lang`)=8));



__________________________________________

MySQL a répondu : Documentation
#1109 - Table inconnue 'id_lang' dans MULTI DELETE
Commenter la réponse de jee pee