Re: Send email via trigger
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';
Subject
Views
Written By
Posted
69755
July 09, 2005 09:24AM
35543
July 09, 2005 04:00PM
23107
July 10, 2005 07:18AM
34831
October 19, 2005 08:53AM
27979
October 20, 2005 09:40AM
24374
October 23, 2005 05:16AM
17198
June 28, 2006 11:53PM
15523
February 13, 2007 06:35AM
15134
May 13, 2007 10:39AM
11564
November 24, 2008 11:10PM
14429
February 22, 2007 03:44AM
12724
December 08, 2007 08:17AM
10248
September 09, 2008 04:00AM
8942
March 12, 2009 07:08AM
18987
February 27, 2007 07:53AM
9741
September 09, 2008 04:02AM
12709
May 14, 2007 01:07AM
Re: Send email via trigger
11914
June 04, 2007 01:14PM
11006
June 27, 2007 10:10PM
10352
August 09, 2007 06:15AM
12723
August 25, 2007 09:13AM
13158
August 30, 2007 01:24AM
16526
August 30, 2007 11:43PM
31899
September 12, 2007 05:39AM
11554
December 08, 2007 03:25AM
8942
December 08, 2007 05:19AM
7705
August 04, 2008 01:15AM
7249
January 12, 2009 05:10AM
7218
January 07, 2009 04:37AM
10508
March 07, 2009 05:11AM
6937
March 12, 2009 06:21AM
8410
March 12, 2009 06:38AM
15862
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.