MySQL Forums
Forum List  »  Triggers

Re: Send email via trigger
Posted by: Jonas Reinhardt
Date: June 04, 2007 01:14PM

One way to implement this is by "select to outfile".
For a windows server with iis use somthing like

select "To: email@address.se","From: triggers@mysql","Subject: Trigger","","Hallo World"
into outfile "/inetpub/mailroot/pickup/mail.txt"
fields terminated by '\r\n';

Options: ReplyQuote


Subject
Views
Written By
Posted
58596
July 09, 2005 09:24AM
31460
July 09, 2005 04:00PM
21079
July 10, 2005 07:18AM
32962
October 19, 2005 08:53AM
25794
October 20, 2005 09:40AM
22817
October 23, 2005 05:16AM
14468
February 13, 2007 06:35AM
13956
May 13, 2007 10:39AM
10658
November 24, 2008 11:10PM
13523
February 22, 2007 03:44AM
11920
December 08, 2007 08:17AM
9453
September 09, 2008 04:00AM
8079
March 12, 2009 07:08AM
17992
February 27, 2007 07:53AM
8974
September 09, 2008 04:02AM
11756
May 14, 2007 01:07AM
Re: Send email via trigger
10892
June 04, 2007 01:14PM
10156
June 27, 2007 10:10PM
9534
August 09, 2007 06:15AM
10949
August 25, 2007 09:13AM
12131
August 30, 2007 01:24AM
15374
August 30, 2007 11:43PM
20700
September 12, 2007 05:39AM
10645
December 08, 2007 03:25AM
8278
December 08, 2007 05:19AM
7064
August 04, 2008 01:15AM
6508
January 12, 2009 05:10AM
6491
January 07, 2009 04:37AM
9561
March 07, 2009 05:11AM
6265
March 12, 2009 06:21AM
7505
March 12, 2009 06:38AM
13848
April 16, 2009 05:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.