[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

Download Coding Interview Book and Get More Tutorials for Coding and Interview Solution: Click Here

Download System Design Interview Book and Get More Tutorials and Interview Solution: Click Here

Do you need more Guidance or Help? Then Book 1:1 Quick Call with Me: Click Here

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. Learn More: Click Here