Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    39

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by pinkfloyd43 View Post
    It's like PHPAdmin will only execute one statement and return one result?
    that is correct

    seems to me that your biggest source of pain is the person who decided to put the same data into 56 different databases
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2010
    Posts
    39
    It's 56 distinct customers, sorry should of indicated that.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yeah, too bad... a single database would've made your job much easier, no?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •