Incredinot Posted November 7, 2012 Share Posted November 7, 2012 Hi, We are a webdevelopment business that host alot of individual sites. So what i want to do is update all our databases at once - but how can this be achieved? What i want to do is update xxx in table xxx in all databases. Is this possible? Or do i need to do it one by one? Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted November 7, 2012 Share Posted November 7, 2012 You have to execute a query against each table that you want to update. There's no 'all tables' wild-card statement. Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted November 7, 2012 Share Posted November 7, 2012 (edited) I would write a php script to do this by simply looping over each database. I'm guessing that all the databases are on the same server. If not you will need to grant access from wherever the script runs. Edited November 7, 2012 by neil.johnson Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.