MySQL Forums
Forum List  »  Newbie

Copy row to other users tables in Wordpress DB?
Posted by: George Bell
Date: April 02, 2015 04:58PM

I am using wordrpess multisite so each site/user has their own similar db tables, with a unique prefix like wp_119_mail_lists

So I want to copy a row of data from one users table and then add that row to the same table of all my other users which would be like
wp_120_mail_lists
wp_121_mail_lists
wp_122_mail_lists

Is that possible to do with sql in phpmyadmin?

I wasn't sure what to google to search for more info on how to do that.

Then I suppose it would be easy for me to take down my site if I make an error so maybe I should find a free lancer to help? Not sure what to ask for if I posted a job?


Any advice much appreciated, thanks!!!
-George

Options: ReplyQuote


Subject
Written By
Posted
Copy row to other users tables in Wordpress DB?
April 02, 2015 04:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.