Hi,...

  We've got a MySQL server running with a lot of different databases that have the 
same table-structure. 

  Does anybody knows how to make an SCRIPT that performs an administrative task (like  
ALTER TABLE 'table_name') in all the databases?

  Do I have to use a script like this ?

  USE database1;
  ALTER TABLE users ..... ;
  USE database2;
  ALTER TABLE users......;
  USE database3;
  .
  .
  .

  (Actually the USE command does not work)

  Thanks a lot to all the people in the list!!!!   :-)

  Best regards,...
  Santiago LLobet

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to