mysql - 将查询 mysql 更新为 VB.net

Question

我在 mysql 上试过这个查询，它运行得很好。

UPDATE tblstocklog 
SET quantity = quantity - 5
WHERE(ProductNo = 25370)
AND quantity >= 5
ORDER BY StockNo ASC LIMIT 1

但是当我用 VB.net 尝试它时，它既不更新也不给出错误消息。

con3.Open()

query3 = "UPDATE tblstocklog set Quantity = Quantity - '" & txt_qty.Text & _
"' WHERE (ProductNo = '" & txt_pno.Text & _ 
"') AND Quantity >= '" & txt_qty.Text & "' ORDER by StockNo ASC LIMIT 1"

Dim cmd3 As MySqlCommand = New MySqlCommand(query, con3)
Dim i3 As Integer = cmd3.ExecuteNonQuery()
con3.Close()

Answer 1

对不起大家，我匆忙完成我的程序，我错过了一个明显的错误。

Dim cmd3 As MySqlCommand = New MySqlCommand(**query**, con3)

查询应该是query3