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.