A sale table records product item, price and quantity. Write a update trigger after a new record is inserted, find total price for this sale.

create table sales

( saleID int NOT NULL Primary Key, productID int NOT NULL, unitPrice decimal(6,2) NOT NULL, quantity int NOT NULL, total decimal(6,2) ); DELIMITER $$ CREATE TRIGGER after_sales_insert AFTER INSERT ON sales FOR EACH ROW BEGIN