Tveitan Posted March 9, 2006 Posted March 9, 2006 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.
Tveitan Posted March 9, 2006 Author Posted March 9, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.