Based on my research this few days, I found that only sql server able to trigger and send email through the database trigger function. while mySQL unable to do that.
another method to do this is create a .asmx web service
References:
1. http://allen-conway-dotnet.blogspot.com/search/label/.asmx2. http://msdn.microsoft.com/en-us/library/swas0fwc(v=VS.100).aspx
