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) E

RE: How to Detect MySql table update/difference

2009-08-05 Thread Daevid Vincent
o:bs...@ymail.com] > Sent: Wednesday, 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

Re: How to Detect MySql table update/difference

2009-08-05 Thread BS TLC
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 table every X

RE: How to Detect MySql table update/difference

2009-08-05 Thread Rolando Edwards
dnesday, 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, and i want to get only the diff

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 ti