At 12:40 -0800 3/9/05, Homam S.A. wrote:
Thanks Tom, Daniel, and Philippe for you replies.
Yes, I got the statement working exactly as I wrote
it. I was confused about this documentation:
http://dev.mysql.com/doc/mysql/en/case-statement.html
which states that you need to specify "END CASE"
instead
Thanks Tom, Daniel, and Philippe for you replies.
Yes, I got the statement working exactly as I wrote
it. I was confused about this documentation:
http://dev.mysql.com/doc/mysql/en/case-statement.html
which states that you need to specify "END CASE"
instead of just "END". So I used the same synt
On Wednesday, March 09, 2005 07:49, Philippe Poelvoorde wrote:
> Daniel Kasak wrote:
>> Homam S.A. wrote:
>>
>>> In the documentation, it doesn't mention which version
>>> of MySQL supports the CASE statement, but it refers to
>>> stored procedures, so is it only supported for 5.x?
>>>
>>> I ca
Daniel Kasak wrote:
Homam S.A. wrote:
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
For example, I can execute the follo
Homam S.A. wrote:
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
For example, I can execute the following in MS SQL
Serve