Detecting Changes in table in order to detect when any changes

[Vijaykumarj]

Receive Notifications when a table record changes between an asp.net web application and an instance of mysql like SQLDependency in SQL Server.

thanks in advance

[bgrainger]

MySQL Server doesn't support the server-side features necessary to make this possible. (In SQL Server, it's based on the Service Broker infrastructure, which doesn't exist in MySQL.)

You'll have to implement some sort of polling based on the shape of the data in your tables (e.g., does it have a TIMESTAMP column or some other value that always changes?):

• https://stackoverflow.com/a/26395181/23633
• https://stackoverflow.com/a/3768609/23633