mysql 事务中查询_在mysql中的1个事务中进行3次查询

我有这个查询首先检查项目是否仍然可用。如果它仍然可用，那么服务器将返回该项目，然后自动递减它..这是我的语法，我想出来的是我只需要请求一次，因此我需要将这3个查询合并成一个。可能吗？我可以要求样品吗？

IF SELECT EXISTS (SELECT * FROM inventorylist WHERE BarcodeNumber = '9555440808279' AND NotificationQuantity > 0)

BEGIN

UPDATE inventorylist SET NotificationQuantity = NotificationQuantity - 1 WHERE BarcodeNumber = '9555440808279';

SELECT * FROM inventorylist WHERE BarcodeNumber = '9555440808279';

END这个语法将会返回一个错误..

[Err] 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 'IF SELECT EXISTS (SELECT * FROM inventorylist WHERE BarcodeNumber = '95554408082' at line 1

[Err] IF SELECT EXISTS (SELECT * FROM inventorylist WHERE BarcodeNumber = '9555440808279' AND NotificationQuantity > 0)

BEGIN

UPDATE inventorylist SET NotificationQuantity = NotificationQuantity - 1 WHERE BarcodeNumber = '9555440808279';