UNIX for Dummies Questions & Answers

Hi All,

In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally.
This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a localServer.DB and RemoteServerDB in the connection command.

Code:

${MYSQLDIR}/mysql -u ${MYusername} --password=${MYAPASSWD} ${MYSQLDB} << SQL
SELECT col1
FROM localDB.tabl1,
        remoteServer.RemoteDB.tab1
WHERE ......with a join

SQL

Many thanks for your help.

Dave

Moderator's Comments:

Please use code tags next time for your code and data.

No, you can't.
With MySQL you can use the federated storage engine to access remote tables from the local instance.