如何从MySQL发送电子邮件5.1 [英] How to send email from MySQL 5.1

问题描述

当一个新行插入到表中时，我正在尝试向多个收件人发送一封电子邮件。收件人列表有所不同。我想使用select语句设置此列表。
我还安装了Navicat，它允许我发送电子邮件通知，但只能发送给预定的一组人。

I'm trying to send an email to several recipients when a new row is inserted into a table. The list of recipients varies. I would like to be able to set this list using a select statement. I also have installed Navicat which allows me to send email notifications but only to a predetermined set of people.

谢谢。

推荐答案

我将非常关心将电子邮件发送到我的数据库服务器上（尽管可能很小）。我可能会提出其中一个选择：

I would be very concerned about putting the load of sending e-mails on my database server (small though it may be). I might suggest one of these alternatives:

1. 应用程序逻辑检测需要发送电子邮件并发送。


2. 有一个MySQL触发器填充一个表，排队要发送的电子邮件，并有进程监视该表和发送电子邮件。

这篇关于如何从MySQL发送电子邮件5.1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！