CODEWITHSUNDEEP
mysql
Parthiban Erusappan
Parthiban Erusappan

Reputation: 45

Is there any way to send email from 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

Upvotes: 0

Views: 1959

Answers (2)

Philipp Sander
Philipp Sander

Reputation: 10249

please don't try to do that...

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.

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

Upvotes: 2

Alfred
Alfred

Reputation: 21406

MySQL is just a database solution, where you can store and retrieve data. For query, you may use a server side scripting like PHP. Then using php, while doing a query, you may send emails. Set up email in your server to send to an id while mysql data is retrieved.

Upvotes: 0

Related Questions