Re: Evaluating text as an expression

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

Re: Evaluating text as an expression

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

Re: Evaluating text as an expression

- 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

Evaluating text as an expression

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%

Re: Evaluating text as an expression

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

Re: Evaluating text as an expression

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 evaluating