See remarks intererspersed in question.
Rhino
- Original Message -
From: "Duncan Miller" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 08, 2005 12:42 AM
Subject: Re: Evaluating text as an expression
> Thanks again,
n the later releases.
Sorry for any confusion I caused!
Rhino
- 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, Novemb
The kind of thing you are talking about,
where you execute 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 a
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 of
See comments interspersed below.
Rhino
- Original Message -
From: "Duncan Miller" <[EMAIL PROTECTED]>
To:
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
> evaluating an expression
