Send Email from MySQL Trigger
-
CREATE TRIGGER send_emailverifier AFTER INSERT, UPDATE ON tbl_users
-
FOR EACH ROW BEGIN
-
SELECT * FROM email_bodies WHERE EmailID = 1;
-
SELECT * FROM tbl_users WHERE ClientID = @ClientID
-
INSERT INTO tbl_emailverify VALUES (UUID, tbl_users.ClientID, OLD.CltEmail, NEW.CltEmail)
-
SELECT concat("To: ",NEW.CltEmail & "," & OLD.CltEmail),
-
"From: triggers@yourmysqlserver.whatever",
-
concat("Subject: ",NEW.subject),
-
"",
-
email_bodies.EmailContent
-
INTO OUTFILE "/inetpub/mailroot/pickup/mail.eml"
-
FIELDS TERMINATED BY '\r\n';
-
END
hwo can i send a email, from mysql??
ReplyDelete