Re: how to use DBI connect to >1 database

You don't say which database, if a database link has been created. Are you saying this query works from whatever client you're using?

Comment on Re: how to use DBI connect to >1 database

Replies are listed 'Best First'.
Re^2: how to use DBI MYSQL connect to >1 database by misterperl (Friar) on Sep 28, 2023 at 16:09 UTC
I dont understand the question about links. I have a mysql database , v 5.7. There are two databases. I have connections and handles to each one: $db1 , $db2. I didn't say the query worked for me at all- the cookbook example just stated the query- they didn't say how to invoke it. My question is , how can I do this in the Perl DBI? I did see some resources mention DBIx which I've never heard of, but those were not in reference to mysql.	[reply]

Replies are listed 'Best First'.

Re^2: how to use DBI MYSQL connect to >1 database
by misterperl (Friar) on Sep 28, 2023 at 16:09 UTC

There are two databases. I have connections and handles to each one: $db1 , $db2.

I didn't say the query worked for me at all- the cookbook example just stated the query- they didn't say how to invoke it. My question is , how can I do this in the Perl DBI?

I did see some resources mention DBIx which I've never heard of, but those were not in reference to mysql.

[reply]