:
Unknown. (Use the SELECT CASE code that's current in the 3.23 branch?)
>Submitter-Id:
>Originator: Daniel Butler
>Organization: Yup Dot Com
>MySQL support: none
>Synopsis: SELECT CASE doesn't work during CREATE TABLE in 4.0.2
>Severity: critical
>
On 29-Jun-01 Sönke Tesch wrote:
> Hi!
>
> The CASE statement doesn't seem to work, even the three examples given in
> the
> docs (7.4.8 Control Flow Functions) return errors:
>
> mysql> select case 1 when 1 then "one" when 2 then "two" else "more" end;
> ERROR 1064: You have an error in your SQ
Hi!
The CASE statement doesn't seem to work, even the three examples given in the
docs (7.4.8 Control Flow Functions) return errors:
mysql> select case 1 when 1 then "one" when 2 then "two" else "more" end;
ERROR 1064: You have an error in your SQL syntax near '1 when 1 then "one" when
2 then "t