Re: How to Detect MySql table update/difference

2009-08-06 Thread Martijn Tonies
Hi, Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds, and i want to get only the different rows in the table. The result that I want to have is simply TABLE (t = now) - TABLE (t = X second ago)

How to Detect MySql table update/difference

2009-08-05 Thread BS TLC
Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds, and i want to get only the different rows in the table. The result that I want to have is simply TABLE (t = now) - TABLE (t = X second ago) Every

RE: How to Detect MySql table update/difference

2009-08-05 Thread Rolando Edwards
[mailto:bs...@ymail.com] Sent: Wednesday, August 05, 2009 10:30 AM To: mysql@lists.mysql.com Subject: How to Detect MySql table update/difference Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds

Re: How to Detect MySql table update/difference

2009-08-05 Thread BS TLC
Message- From: BS TLC [mailto:bs...@ymail.com] Sent: Wednesday, August 05, 2009 10:30 AM To: mysql@lists.mysql.com Subject: How to Detect MySql table update/difference Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database

RE: How to Detect MySql table update/difference

2009-08-05 Thread Daevid Vincent
, August 05, 2009 2:57 PM To: Rolando Edwards; mysql@lists.mysql.com Subject: Re: How to Detect MySql table update/difference Ok, but in this way I can only detect if it's done ONE type of operation, for example if I add a row and I remove an another one with this query I detect