Need help with my MySQL PROCEDURE #1193 - Unknown system variable
You need to declare variable first and then only you can set the value.

Something like:

DECLARE price_per_meter DECIMAL(6,2);


Then other part is just logics.