如何从 MySQL 5.1 发送电子邮件

2021-11-20 00:00:00 email notifications mysql navicat

当向表中插入新行时，我正尝试向多个收件人发送电子邮件.收件人列表各不相同.我希望能够使用 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 触发器填充一个表，该表将要发送的电子邮件排队，并让一个进程监控该表并发送电子邮件.

相关文章