mysql - 计算买入价的 10% 利润

Question

我有这个脚本计算利润

步骤:

• barangbeli = 哈萨特/直径
• p1 = 巴朗贝利 * 10
• p2 = 教授/100
• 结果 = barangbeli + 利润；

谢谢

CREATE VIEW tbkeluar as 
SELECT  mbarang.kdbrg, mbarang.nmbrg, mbarang.spek,if(SUM(bkeluar.qty), SUM(bkeluar.qty), 0)as qty,(tbmasuk.harsat/mbarang.diameter) as hargabeli, ((hargabeli*10)/100 )+hargabeli) as profit
LEFT JOIN bkeluar on mbarang.kdbrg = bkeluar.kdbrg group by mbarang.kdbrg  

我有错误

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as profit from mbarang
LEFT JOIN bkeluar on mbarang.kdbrg = bkeluar.kdbrg gro' at line 2  

Answer 1

您收到的错误消息应该足以帮助您了解问题所在。

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as profit from mbarang LEFT JOIN bkeluar on mbarang.kdbrg = bkeluar.kdbrg gro' at line 2

根据错误消息，MySQL 表示由于此字符 )，您有一个语法错误，并为您附加了一些字符找到它:)作为 mbarang 的利润

正如您从 SELECT 语句中看到的，您有一个额外的 )

SELECT  mbarang.kdbrg
    , mbarang.nmbrg
    , mbarang.spek
    ,if(SUM(bkeluar.qty), SUM(bkeluar.qty), 0)as qty
    ,(tbmasuk.harsat/mbarang.diameter) as hargabeli
    , ((hargabeli*10)/100 )+hargabeli) as profit
                                     ^ delete this extra parenthesis