from那行语法错在哪里了 一直报错

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 'FROM my_stock join inserted b\n\t\t WHERE a.stock_id = b.stock_id;\n\n\t\t UPDATE m' at line 23

你这是sqlserver语法
mysql要用inner join

UPDATE a
INNER JOIN b

ON a.stock_id= b.stock_id

SET a.valume=a.valume+1