See remarks intererspersed in question.
Rhino
- Original Message -
From: Duncan Miller [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 08, 2005 12:42 AM
Subject: Re: Evaluating text as an expression
Thanks again, I am certainly learning
The kind of thing you are talking about,
where youexecute a text string that is supplied at runtime, is called
dynamic SQL. I've used it in the database which I use most of the time, DB2, but
had never seen it in MySQL when I was making my initial reply to your question.
I just had a look
- Original Message -
*From:* Duncan Miller mailto:[EMAIL PROTECTED]
*To:* Rhino mailto:[EMAIL PROTECTED]
*Cc:* mysql@lists.mysql.com mailto:mysql@lists.mysql.com
*Sent:* Monday, November 07, 2005 1:22 AM
*Subject:* Re: Evaluating text as an expression
Thanks.
I see
See comments interspersed below.
Rhino
- Original Message -
From: Duncan Miller [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, November 06, 2005 8:36 PM
Subject: Evaluating text as an expression
I am trying to set up a table where the returned value is a result of
Thanks.
I see what you mean. I used the 'Evaluate' as an example because in some
code you can use that function to execute a text string as code. I sort
of thought there may be something similar in SQL / MySQL to allow the
execution of a resultant string as if it were code.
And yeah a lot