有没有办法从mysql发送电子邮件 [英] Is there any way to send email from mysql

问题描述

在 mysql 服务器中手动执行查询时，是否可以发送电子邮件.我们可以在 mysql 触发器中执行此操作吗，请告诉我在 mysql 中运行某些查询时如何获取电子邮件

Is there is way to send email when query executed manually in mysql server. Can we do this in mysql trigger please advise me how do we get email when some query run in mysql

推荐答案

请不要尝试这样做...

please don't try to do that...

MySQL 是一个纯粹的数据库，它不负责发送电子邮件.MySQL 没有电子邮件功能以太.

MySQL is a pure Database it's not its business to send eMails. MySQL has no eMail functionality ether.

我建议创建一个新表并在使用该过程时在该表中写入一个元组.

i'd recommend creating a new table and write a tuple in that table when the procedure is used.

然后轮询该表(使用 Java 应用程序左右)并发送邮件

Then poll that table (with a java application or so) and send the mail

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