mysqlÈýÄ¿ÔËËãʹÓÃʾÀý
2019/10/10/17:37:58 ÔĶÁ£º1187 À´Ô´£º¹È¸èSEOËã·¨ ±êÇ©£º
SEO
ÈýÄ¿ÔËËã¾ÍÊÇÒ»¸ö¼òµ¥µÄif elseµÄÅжÏÁË,µ«ÊÇÈýÄ¿ÔËËã±Èif else¸ü¼ò½àºÃÓÃÁË,ÄÇÖªmysqlÖÐÖ§³ÖÈýÄ¿ÔËËãÂð£¿Ò»ÆðÀ´¿´¿´.
ÍøÕ¾ÒµÎñÐèÒª°´Êµ¼Ê³ÉÁ¢½ð¶îÅÅÐò,ÒªÓõÄÓÐÈý¸ö×Ö¶Î:price£¨ÉÌÆ·¼Û¸ñ£©,pay£¨Êµ¼ÊÖ§¸¶¼Û¸ñ£©,num£¨¹ºÂòÊýÁ¿£©,Èç¹ûÉÌÆ·ÓÐÓŻݾÍÊÇ°´pay¼Û¸ñ³ÉÁ¢,Ò²¾ÍÊÇpay>0,Èç¹ûûÓÐÓŻݾÍÊÇʵ¼Û³É½»,pay=0.ËùÒÔÎÒÃÇÒªµÄʵ¼Ê¼Û¸ñ¾ÍÊÇÈç¹ûpay>0¾ÍÊÇpay*num£¬·ñÔò¾ÍÊÇprice*num.ÕâÒ²¾ÍÊÇÒªÓõ½ÈýÄ¿ÔËËãpay>0?pay:price.
ÄÇômysqlÓÐÈýÄ¿ÔËËã·ûÂð:
¿ÉÒÔÓÃcase when,Õâ¸ömysqlÓ¦¸ÃÖ§³Ö:select a,case when b is null then'xxxx' else b end b from table_xxx where,»¹ÓÐÕâ¸ö.
sqlÖÐÒ²ÊÇÖ§³ÖÈýÄ¿ÔËËãµÄ,Ó﷨Ϊ:
CASE WHEN Ìõ¼þ THEN Èç¹û·ûºÏ ELSE Èç¹û²»·ûºÏ END
ËùÒÔÔÚÎÒÃÇÕâÒµÎñÖеÄSQLÓï¾ä¾ÍÊÇ:
select CASE WHEN pay>0 THEN pay*num ELSE price*num END as ‘amount’ from table_name order by amount desc;//phpfensi.com