you can also use expect...such as:
#!//expect
spawn mysql -u root -p
expect "password:"
send "password\r"
expect "mysql>"
send "use db1"
expect "mysql>"
send "alter table ...\r"
expect "mysql>"
send "exit\r"
expect eof
also, since expect uses the tcl language, you could create a tcl list wit
ursday, April 05, 2001 8:50 PM
To: Santiago LLobet
Cc: [EMAIL PROTECTED]
Subject: Re: SCRIPTS IN DIFFERENTS DATABASES
On Thu, 5 Apr 2001, Santiago LLobet wrote:
> Hi,...
>
> We've got a MySQL server running with a lot of different databases that
have the same table-structu
On Thu, 5 Apr 2001, Santiago LLobet wrote:
> 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 d
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 ?
US
