如何使用循环函数查询。 [英] How Do I Use Round Function Query.

问题描述

尊敬的先生或女士



我必须在我的SQL查询中使用循环函数将结果舍入为2位小数。



这是我的查询。



$ RES = mysql_query（更新Pyament set Received =收到+ $ GrandTotal，salereceived = salereceived + $ GrandTotal其中M_id = 1和G_id = 1）





我想使用round函数来更新Received和salereceived。



请帮帮我。

Dear Sir Or Madam

I have to use round function in my sql query to round the result for 2 decimals.

Here is my query.

$RES=mysql_query("update Pyament set Received=Received+$GrandTotal, salereceived=salereceived+$GrandTotal where M_id=1 and G_id=1")


I want to use round function to update Received and salereceived.

please help me.

推荐答案

RES = mysql_query（更新Pyament set Received = Received +

RES=mysql_query("update Pyament set Received=Received+

GrandTotal，salereceived = salereceived +

GrandTotal, salereceived=salereceived+

GrandTotal，其中M_id = 1且G_id = 1）





我想使用圆形功能来更新已接收和已售出。



请帮帮我。

GrandTotal where M_id=1 and G_id=1")


I want to use round function to update Received and salereceived.

please help me.

这篇关于如何使用循环函数查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！