470,594 Members | 1,412 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

Evaluting STRING expression as SQL

Hi:
It is possible to execute string expressions in mysql?
I mean, i need to execute as SQL (in a SP) some string like this:

DECLARE sql;
DECLARE qid BigInt;
SET sql = 'SELECT * FROM table WHERE idx = ' + qid;
SOME_EXECUTE_FUNCTION(sql);

The real problem is: I have a table with 2 columns, 1 Autonumeric, and
2 VarChar column. In this varchars columns i store some table names. I
Need to retrieve one row (easily :)) and make a select in between this
2 tables that the varchars columns return. This must be inside a Stored
Procedure.

I Can't found anything in the web, it is this possible? how can i
solve?

Thank you beforehand

May 31 '06 #1
1 1566
lu******@gmail.com wrote:
It is possible to execute string expressions in mysql?


Yes, read this doc page:
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html

Regards,
Bill K.
May 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Igor2004 | last post: by
reply views Thread by Igor Nikiforov | last post: by
25 posts views Thread by tienlx | last post: by
3 posts views Thread by Coco | last post: by
32 posts views Thread by tshad | last post: by
7 posts views Thread by Brian Mitchell | last post: by
20 posts views Thread by Opettaja | last post: by
1 post views Thread by NvrBst | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.