Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL UPDATE question


Tveitan

Recommended Posts

Posted

Hello.

 

Anyone know the correct syntax for updating multiple tables in mysql. I want to update the language_id in categories_description, coupons_description, languages, languages_to_stores, orders_status, coupons_description, languages_to_stores, orders_status, products_description, products_options, products_options_values and reviews_description. From language_id 4 to 1..

 

Thanks for help.

Posted

Tried

 

UPDATE `categories_description`, `coupons_description`, `languages`, `languages_to_stores`, `orders_status`, `products_description`, `products_options`, `products_options_values`, `reviews_description` SET `language_id` = 1 WHERE `language_id` =4;

 

but no luck

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...