Superbegood31 Posted November 13, 2017 Share Posted November 13, 2017 (edited) Bonjour, Après plusieurs jours de recherche je ne trouve pas la solution à mon problème. Je souhaite mettre à jour mes descriptions produits à partir de la langue FR vers toutes les autres langues (x7). J'ai essayé cette requête mais sans succès : UPDATE ps_product_lang SET description = (SELECT description FROM ps_product_lang WHERE id_lang = 1) WHERE id_lang > 1 Merci pour vos lumières, je suis ouvert à toutes propositions. Bruce Edited November 13, 2017 by Superbegood31 Résolu (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted November 13, 2017 Share Posted November 13, 2017 update ps_product_lang pl inner join ps_product_lang pl1 on pl1.id_product = pl.id_product and pl1.id_lang = 1 set pl.description = pl1.description where pl._d_lang != 1 1 Link to comment Share on other sites More sharing options...
Superbegood31 Posted November 13, 2017 Author Share Posted November 13, 2017 Bonjour et merci doekia Ta requête marche super bien! En grand merci Bruce Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now