Requête Delete : Supprimer des enregistrements sur plusieurs tables

traderpierre Messages postés 291 Date d'inscription Statut Membre Dernière intervention -
traderpierre Messages postés 291 Date d'inscription Statut Membre Dernière intervention - 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

A voir également:

Requête Delete : Supprimer des enregistrements sur plusieurs tables
Hiberfil.sys delete - Guide
Juste delete me - Guide
Requête bloquée par le pare-feu applicatif claranet webfence ✓ - Forum Réseaux sociaux
Requete sql pix - Forum PHP
*#9900# delete dumpstate/logcat - Forum Samsung

2 réponses

Réponse 1 / 2

jordane45 Messages postés 38486 Date d'inscription Statut Modérateur Dernière intervention 4 752

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

Réponse 2 / 2

jee pee Messages postés 41520 Date d'inscription Statut Modérateur Dernière intervention 9 720

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 291 Date d'inscription Statut Membre Dernière intervention 6

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 291 Date d'inscription Statut Membre Dernière intervention 6

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

Discussions similaires

Suppression de boot option

mémoire saturé sur Samsung

site bloqué par Claranet

Certification Pix - Python et SQL

Emplacement de la touche "Supprimer"

Votre réponse

Discussions similaires