将新记录插入数据库表时的任务栏通知 [英] Taskbar notification when a new record has been inserted into a database table
问题描述
我正在处理一个项目,只要在数据库表中插入了新记录,就会通知用户。
例如我有一个供用户使用的表,当新用户的记录插入到users表中时,任务栏上会弹出一个通知。 />
下一个例子,我运行查询:INSERT INTO之后,任务栏消息也会显示插入新记录的消息
我可以通过在mySQL中使用触发器来实现这一目的吗?我不会使用任何winform应用程序,显然将从sql server本身运行。
I'm handling a project which a user is to be notified whenever a new record has been inserted in the database table.
for example I have a table for users, and when a record for new user is inserted into the users table, a notification will pop out on the taskbar.
next example, I run the query: "INSERT INTO" after which, a taskbar message will also show a message that a new record was inserted
can I achieve this by simply using triggers inside mySQL? I will not use any winform applications with this, plainly will run from sql server itself.
推荐答案
你可以有邮件通知,参考
http://solutioncenter.apexsql.com/get-an-alert-什么时候记录更改/ [ ^ ]
-KR
You can have mail notifications instead, refer
http://solutioncenter.apexsql.com/get-an-alert-when-a-certain-record-changes/[^]
-KR
这篇关于将新记录插入数据库表时的任务栏通知的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!