mysql_crud

最新推荐文章于 2024-08-06 16:09:13 发布

banqi9092

最新推荐文章于 2024-08-06 16:09:13 发布

阅读量66

点赞数

原文链接：http://www.cnblogs.com/DLGD/p/7857439.html

版权

多分支查询

SELECT 
(CASE WHEN (marketprice > 0.1 and marketprice < 2) then marketprice + 1       
WHEN (marketprice > 2.1 and marketprice < 5) then marketprice + 3  
WHEN (marketprice > 5 and marketprice < 10) then marketprice + 5  
WHEN (marketprice > 10 and marketprice < 20) then marketprice + 10 
WHEN (marketprice > 20 and marketprice < 30) then marketprice + 18
WHEN (marketprice > 30 and marketprice < 50) then marketprice + 30   
WHEN (marketprice > 50 and marketprice < 100) then marketprice + 40  
else null end) AS  marketprice 
from ims_ewei_shop_goods;

分库分表

实践：http://blog.csdn.net/czbing308722240/article/details/52350219

转载于:https://www.cnblogs.com/DLGD/p/7857439.html