Re: calcular el total de una columna al insertar

[Wolfgang Moriske]

Hola Fausto!

Quizás puedas resolverlo con un "Trigger"

Insert:

CREATE TRIGGER before_cust_order_insert
BEFORE INSERT ON cust_order
FOR EACH ROW
SET new.total = new.cant * new.precio


Update:

CREATE TRIGGER before_cust_order_update
BEFORE UPDATE ON cust_order
FOR EACH ROW
SET new.total = new.cant * new.precio