LWtnM2Fy

1CREATE TABLE IF NOT EXISTS `testing`
2(
3    `testing_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
4    `meter` INT NOT NULL,
5    `price` DECIMAL(12,2) NOT NULL,
6    `price_per_meter` DECIMAL(10,2) NOT NULL,
7    PRIMARY KEY (`testing_ID`)
8)
9	
10DELIMITER $$
11CREATE PROCEDURE `price_per_meter_calc` (price DECIMAL(12,2))
12BEGIN
13    SET price_per_meter = price/meter;
14END
15$$
16DELIMITER ;
17	
18DECLARE price_per_meter DECIMAL(6,2);