Easy Question about MySQL

[big24fan]

I have a MySQL Database with several tables that have the same fields in them. I have updated the "cp_ads_welcome_msg" field of the "WP_7_OPTIONS" table with the data that I would like to update all the other tables with. This code works if wanted to update each table one at a time.

REPLACE INTO wp_9_options
SELECT * 
FROM wp_7_options
WHERE wp_7_options.option_name = "cp_ads_welcome_msg";

There are 650 tables though. I would like to know how I could update all tables at the same time. The tables are named "WP_XXX_Options"
I have tried manipulating this code as much as I can figure out, but nothing works. Can someone help me out here?

[macobex]

I think you should use a separate table to store the "cp_ads_welcome_msg" field and use foreign key on all the "WP_XXX_Options" to reference the "cp_ads_welcome_msg" field.

By doing this, you only need to update one table and all the "WP_XXX_Options" will point to the same "cp_ads_welcome_msg".

Hope it helps.

[EmilyJohnson]

I think you should use Update keyword instead of Replace keyword and for more information you will visit this link:
http://dev.mysql.com/doc/refman/5.0/en/update.html

Hope This Helps You.