Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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

by pryrt (Abbot)
on Jan 24, 2018 at 18:07 UTC ( [id://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.