List:General Discussion« Previous MessageNext Message »
From:Sapenov Date:August 16 2004 5:22pm
Subject:Re: Database Stats
View as plain text  
prototype of PHP script

$db_stack=array("ip,user,pass,dbname,table","ip2,user2,pass2,dbname2,table2"
,...);
$resultset=array();
foreach($db_stack as $k=>$v){
/// query database and get results
$resultset[].=$portion_of_information;
}

foreach($resultset as $k=>$v){
//append row and save as csv file
}

regards,
Khazret Sapenov

----- Original Message ----- 
From: "David Mohorn" <dm4714@stripped>
To: <mysql@stripped>
Sent: Monday, August 16, 2004 12:58 PM
Subject: Database Stats


>
> I have about 25 databases that I need to run the same query against that
> returns about 5 columns of information.
>
> I need this information then published within an Excel spreedsheet.
>
> What is the best way do handle this?
>
> Currently, I'm running each query manually, copying/pasting the result
> to Excel, and repeating...
>
> I need to run this procedure every week, and it takes a considerable
> amount of time.
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>


Thread
Database StatsDavid Mohorn16 Aug
  • Re: Database StatsMartijn Tonies16 Aug
  • Re: Database StatsSapenov16 Aug
  • Re: Database StatsBrent Baisley16 Aug
  • Re: Database StatsSGreen17 Aug