[MySQL] After Insert Trigger Sum all value of a column

CREATE TRIGGER `mytrigger` AFTER INSERT ON `iot`
 FOR EACH ROW BEGIN
   DECLARE a float;
   DECLARE b float;
   DECLARE c float;
   DECLARE d float;
 
   
    SELECT SUM(bill) into c from iot;
    SELECT SUM(unit) into d from iot;
   
    INSERT INTO list
    VALUES('',c,d);
       
END

Share on Google Plus

About Ashadullah Shawon

I am Ashadullah Shawon. I am a Software Engineer. I studied Computer Science and Engineering (CSE) at RUET. I Like To Share Knowledge.