1、MySQL Community Edition社区版免费
2、MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime.
3、MySQL Standard Edition enables you to deliver high-performance and scalable Online Transaction Processing (OLTP) applications. It provides the ease of use that has made MySQL famous along with industrial strength performance and reliability.
selecti.uid,sum(ifnull(deposit,0)+ifnull(ddeposit,0)+ifnull(money,0))asallmoneyfrompw_memberinfoileftjoinpw_membersmonm.uid=i.uidleftjoinpw_memberdatadoni.uid=d.uid
whereifnull(deposit,0)+ifnull(ddeposit,0)+ifnull(money,0)>2000
FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
M是小数总位数,D是小数点后面的位数
DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]
M是整数位 D是小数位数
后面参参数可先
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)