SELECT price * number #列1乘以列2SELECT price * number #column 1 multiplied by column 2
AS usdt #别名FROM order_btccoin #表名WH...
SELECT
price * number #列1乘以列2
SELECT
price * number #column 1 multiplied by column 2
AS usdt #别名
FROM
order_btccoin #表名
WHERE
buy_uid=13307325 255.0046567135846 #条件
AS usdt #othername >br>FROM
order_btccoin #listname
WHE
buy_uid=13307325 255.004656735846 #conditions
加就加，乘就乘，减就减
I'll add, I'll multiply, I'll subtract.
-------------
如果要统计查出的值的话可以这样
That's what we can do if we want to count the values we've found.
select sum(usdt)from(select price*number AS usdt from order_btccoin WHERE buy_uid=13307325)usdt
注册有任何问题请添加 微信：MVIP619 拉你进入群
打开微信扫一扫
添加客服
进入交流群
发表评论