Hello.
Very often PREPARED STATEMENTS are helpful in similar situations. For a pity,
they are disabled in the current release. See:
http://dev.mysql.com/doc/mysql/en/sqlps.html
Leonardo Javier Belén wrote:
> Hi all,
> I am wondering if I can construct a query string inside a stored
> procedure and then execute it. I mean, what I want to do is given a set of
> IN parameters, be able to construct a huge where statement out of them an
> then complete the query string to execute. Is that possible? because if that
> is possible I could be able to abstract all the data logic from the program
> itself.
>
> I've been googling and reading books and references without success so
> far, but I think the functionality should be there, what I dont know is how
> to use it.
>
> Thanks in advance.
>
> sql - query - mysql
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
