Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re^2: Perl DBI not storing @prev_value in query

by pryrt (Monsignor)
on Jan 24, 2018 at 18:07 UTC ( #1207855=note: print w/replies, xml ) Need Help??

in reply to Re: Perl DBI not storing @prev_value in query
in thread Perl DBI not storing @prev_value in query

A few months back, I was able to get some proof of concept code working. See my thread, especially the summary code in this post. I don't know whether the things I learned in that set of experiments will help, but I was able to make use of the @dmvar user-defined variable; I don't think it had to be inside of the DebugMe mySQL function to work... that's just specifically what I was trying to get at for that one. But I thus know that user-defined variables aren't out of the question in DBD::mysql.

(caveat: not an SQL or mySQL expert)

Replies are listed 'Best First'.
Re^3: Perl DBI not storing @prev_value in query
by Mr. Muskrat (Canon) on Jan 24, 2018 at 19:35 UTC

    I haven't used MySQL for many years now (not since I left Lacuna Expanse any way) so I'm by no means an expert either.

    I just don't know enough about MySQL's user-defined variables. I would totally expect them to work inside of stored functions. If they work as a part of normal queries as well then it would useful if the DBD::mysql documentation at least mentioned them.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1207855]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2022-06-29 07:18 GMT
Find Nodes?
    Voting Booth?
    My most frequent journeys are powered by:

    Results (96 votes). Check out past polls.