How to invoke the application Using Mysql Command

I am writing a trigger, in which i need开发者_StackOverflow to invoke the external application using the MySQL

Looking a your comment, the response is obvious. Write a program in whichever language you dominate the best. That program needs to

1. Read all email addresses
2. Iterate on the list
3. Send a mail in every iteration

If you promise not to use it for sending spam, I can give you a basic PHP script to do that

I would suggest having the external application request the list of users, and then looping through the list and sending the email. There's no real reason to mix the two.