UPDATE A set A.amount = A.amount
FROM product_in_stock AS A
INNER JOIN move_str_start AS B ON A.id_model = B.id_model
WHERE B.id_move=121 AND A.id_stock=7;
我有錯誤：
您的 SQL 語法有錯誤；檢查與您的 MariaDB 服務器版本相對應的手冊，以在第 1 行的“FROM product_in_stock AS A INNER JOIN move_str_start AS B ON A.id_model = B.id_m”附近使用正確的語法
uj5u.com熱心網友回復：
update product_in_stock AS A
INNER JOIN move_str_start AS B ON A.id_model = B.id_model
SET A.amount=A.amount B.count
WHERE B.id_move=121 AND A.id_stock=7;
PS這是答案
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/432593.html
上一篇：通過考慮配對列的值是否在另一個資料幀中配對列的值范圍內來連接兩個資料幀
下一篇：FileNotFoundError，當我運行shutil.copy時，1個特定的“.dylib”檔案每次都會拋出FileNotFoundError錯誤