var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: PHPAdmin & Multiple Select Statements
I am tasked weekly to run some SQL again many databases and PHPAdmin is all I have to do it with.
I want to connect to DB1 run a script that counts rows from a few tables then connect DB2 and do the same. All the way up to DB56. I have been doing this manually for a few weeks now and it's not fun!
I can't figure out how to get the PHPAdmin toolset to accept multiple SQLstatements and display ALL the results at once. It's like PHPAdmin will only execute one statement and return one result?
Sorry if this is a basic question as am still learning about PHPAdmin and MySQL and appreciate any help. Thanks!
From The Dark Side Of the Moon
that is correct
Originally Posted by pinkfloyd43
seems to me that your biggest source of pain is the person who decided to put the same data into 56 different databases
It's 56 distinct customers, sorry should of indicated that.
yeah, too bad... a single database would've made your job much easier, no?
Tags for this Thread