mysql中输入电子邮箱,如何使用MySQL Server发送电子邮件？

最新推荐文章于 2022-05-16 20:52:18 发布

汤汤七号

最新推荐文章于 2022-05-16 20:52:18 发布

阅读量392

点赞数

文章标签： mysql中输入电子邮箱

I am using MySQL server 5.0. I have a table named User_Login_Details. I want to receive email from my MySQL server when anyone tries to change anything in my Table. That may be Insert, Update or Delete.

How can I do this?

解决方案

As far as i know, i don't think MySQL server has no default SMTP setup or utilities packaged in. You will need to monitor the logs and generate mails yourself. If you are using it along with any other language such as PhP,Java,Python, C# then you can program an evented/polling model for this which will notify you in case of any change. Anyways you would have to monitor the logs. If binary logs are enabled, then you can write a script to notify changes.

If you do not want to monitor the logs, then you Could Monitor information_schema.tables. Loop through every table and check its UPDATE_TIME column in information_schema.tables