Can you send an email using a MySQL event?

Question

I want to send an email if someone has not returned their checked out item back into the system. If current date is > return date, then an email will be sent notifying the user that they need to return their item.

I came across MySQL events, and am wondering if it is possible to create a MySQL event that sends an email if a certain condition is met.

I'd like my event to send emails to the user who has not returned the item.

https://stackoverflow.com/questions/28917411/send-email-from-mysql-trigger-when-a-table-updated — spencer7593, Apr 30 '19 at 14:11
https://stackoverflow.com/questions/387483/how-to-send-email-from-mysql-5-1 — spencer7593, Apr 30 '19 at 14:12
https://stackoverflow.com/questions/19316582/is-there-any-way-to-send-email-from-mysql — spencer7593, Apr 30 '19 at 14:12
https://stackoverflow.com/questions/31019188/how-to-send-email-using-mysql-server — spencer7593, Apr 30 '19 at 14:13
https://stackoverflow.com/search?q=can+you+send+email+from+mysql+event — spencer7593, Apr 30 '19 at 14:14

score 0 · Accepted Answer · answered Apr 30 '19 at 14:21

No, there's no native "send email" function in MySQL database server.

As far as MySQL EVENT, it is possible to execute queries, and check conditions, and perform DML operations i.e. insert/update/delete row(s) e.g. into a queue table. And another "client" can run a query against the queue table, and send email.

It is possible to incorporate additional functionality into the MySQL server by creating a user defined function. But IMO that's a chase down the wrong rabbit hole.

https://dev.mysql.com/doc/refman/8.0/en/adding-functions.html

Please refer to other questions on the same topic of sending email from MySQL server.

as a starting point:

https://stackoverflow.com/search?q=can+you+send+email+from+mysql+event

Can you send an email using a MySQL event?

1 Answers1