[MySQL] After Insert Trigger Sum all value of a column database , mysql Edit 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 Facebook Share on Twitter 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. RELATED POSTS
0 comments:
Post a Comment