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
ino wrote:
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 res
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
I am trying to set up a table where the returned value is a result of
evaluating an expression that is stored as text (or varchar).
The idea is to have a table with a couple of fields that can contain
numeric values or expressions eg
NameFred
Years 3
Commission base 10%
Commissi
