Skip navigation links

MySQL Forums :: Triggers :: Send email via trigger


Advanced Search

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
Send email via trigger 44542 Chris Huber 07/09/2005 09:24AM
Re: Send email via trigger 25806 Jay Pipes 07/09/2005 04:00PM
Re: Send email via trigger 18492 Chris Huber 07/10/2005 07:18AM
Re: Send email via trigger 30146 Dave Revor 10/19/2005 08:53AM
Re: Send email via trigger 22545 Andrew Gilfrin 10/20/2005 09:40AM
Re: Send email via trigger 20609 Konstantin Osipov 10/23/2005 05:16AM
Re: Send email via trigger 14303 Mathan Kumar Kanagaraj 06/28/2006 11:53PM
Re: Send email via trigger 13049 Ravi Gujjarlapudi 02/13/2007 06:35AM
Re: Send email via trigger 12588 Philip Bannon 05/13/2007 10:39AM
Re: Send email via trigger 9346 kamal sekar 11/24/2008 11:10PM
Re: Send email via trigger 12278 Chintaoui Chintaoui 02/22/2007 03:44AM
Re: Send email via trigger 10690 Zigmund Bulinsh 12/08/2007 08:17AM
Re: Send email via trigger 8367 satyendra saini 09/09/2008 04:00AM
Re: Send email via trigger 7080 Eduard Filipas 03/12/2009 07:08AM
Re: Send email via trigger 16878 Chintaoui Chintaoui 02/27/2007 07:53AM
Re: Send email via trigger 8066 satyendra saini 09/09/2008 04:02AM
Re: Send email via trigger 10772 ifti khirul 05/14/2007 01:07AM
Re: Send email via trigger 9921 Jonas Reinhardt 06/04/2007 01:14PM
Re: Send email via trigger 9291 ifti khirul 06/27/2007 10:10PM
Re: Send email via trigger 8726 Karthikeyan karthi 08/09/2007 06:15AM
Re: Send email via trigger 9301 por por 08/25/2007 09:13AM
Re: Send email via trigger 11141 Matt H 08/30/2007 01:24AM
Re: Send email via trigger 13991 Jonas Reinhardt 08/30/2007 11:43PM
Re: Send email via trigger 15968 Benjamin Howarth 09/12/2007 05:39AM
Re: Send email via trigger 9799 Zigmund Bulinsh 12/08/2007 03:25AM
Re: Send email via trigger 7546 Zigmund Bulinsh 12/08/2007 05:19AM
Re: Send email via trigger 6295 shyamsundar Ayyanan 08/04/2008 01:15AM
Re: Send email via trigger 5644 Umar Md 01/12/2009 05:10AM
Re: Send email via trigger 5752 shafikhan mohammed 01/07/2009 04:37AM
Re: Send email via trigger 8040 Adrian Hondema 03/07/2009 05:11AM
Re: Send email via trigger 5355 Anthony Whitley 03/12/2009 06:21AM
Re: Send email via trigger 6458 Anthony Whitley 03/12/2009 06:38AM
Re: Send email via trigger 11053 Howard Brinsmead 04/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.