Mysql Variables & Branches

SELECT Case3 when1Then' One' when2Then' Both'ELSE' More'END; SELECT Case1>0Then'true'ELSE'false'END as' One', case0>0Then'true'ELSE'false'END as' Both'; SELECT Case BINARY'BB' when'a'Then1 when'BB'Then2END; SELECT Case'B' when'a'Then1 when'b'Then2END; SELECT IF (1>2,2,3);SelectSTRCMP ('Text2','text'); To use variables to hold the data, use the @ variable set @cq directly:= (SELECT a.id from emis.view1 A WHERE id =6); SELECT @cq as'how variable declarations are assigned'; SET @c= (SELECT a.printer_addr from emis.view1 A WHERE id =@cq); SELECT @c as'methods for assigning values to variable declarations @cq find'Note the above two assignment symbols, which can be used when set .= "or": = ", but must be used when using select": =Assignment "Select @bb:=id from emis.view1 A WHERE id =@cq; SELECT @bb;

Mysql Variables & Branches