Exercise

FORMATMESSAGE with message string

Every time you sell a bike in your store, you need to check if there is enough stock. You prepare a script to check it and throw an error if there is not enough stock.

Today, you sold 10 'Trek CrossRip+ - 2018' bikes, so you need to check if you can sell them.

Instructions

100 XP

Save into the @current_stock variable the value of the stock of the product.
Use the FORMATMESSAGE function with parameter placeholders (%s, %d, ... ) to customize the error message. The message has to be 'There are not enough (the given product name) bikes. You only have (the stock of the product) in stock.'
Pass to the THROW statement the custom message.

Take Hint (-30 XP)