MySQL Forums
Forum List  »  PHP

Re: SQL newbie question
Posted by: Peter Brawley
Date: August 28, 2020 09:52AM

SQL is by design an incomplete language, somewhat literal-minded.

Used as a statement, https://dev.mysql.com/doc/refman/5.7/en/case.html, each CASE may specify one or more statements in a statement_list.

But used as n your case as an operator on a Select expression, https://dev.mysql.com/doc/refman/5.7/en/control-flow-functions.html#operator_case, each CASE specifies one alternative ... each comma-delimited Select expression may specify just one column of the resultset.

Options: ReplyQuote


Subject
Written By
Posted
August 27, 2020 05:37PM
Re: SQL newbie question
August 28, 2020 09:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.