hi, I want to create a script which will update a table in a number of databases under the same host, all databases have the same prefix.
I am not able to figure out the syntax of it though, can you help me out?
update values in specific databases
Thanks for the reply, here are some things i did not clarify:
The number of databases is unknown and the script should be able to handle that (to retrieve the databases and update each one)
Also the suffix of the table is not known, only the prefix is known, so the tables could be named like prefix_<something>
The number of databases is unknown and the script should be able to handle that (to retrieve the databases and update each one)
Also the suffix of the table is not known, only the prefix is known, so the tables could be named like prefix_<something>
Please login to leave a reply, or register at first.