Skip to main content
Database Administrators

Return to Answer

Added a code block
Source Link
edit approved Mar 30, 2020 at 12:11
armitage
edit approved Mar 30, 2020 at 12:11
armitage
  • 1.4k
  • 2
  • 14
  • 20

update products_description pd1, (select products_seo from products_description where language_id = 1) pd2 set pd1.products_seo = p2.products_seo where pd1.products_id = p2.products_id and pd1.language_id <> 1;

update products_description pd1,
 (select products_seo from products_description where language_id = 1) pd2
set pd1.products_seo = p2.products_seo
where pd1.products_id = p2.products_id and pd1.language_id <> 1;

update products_description pd1, (select products_seo from products_description where language_id = 1) pd2 set pd1.products_seo = p2.products_seo where pd1.products_id = p2.products_id and pd1.language_id <> 1;

update products_description pd1,
 (select products_seo from products_description where language_id = 1) pd2
set pd1.products_seo = p2.products_seo
where pd1.products_id = p2.products_id and pd1.language_id <> 1;
Source Link
na.vaithianathan
na.vaithianathan
  • 11

update products_description pd1, (select products_seo from products_description where language_id = 1) pd2 set pd1.products_seo = p2.products_seo where pd1.products_id = p2.products_id and pd1.language_id <> 1;