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)
I have good news and bad news for you when it comes to MySQL 5.x.
Good News if you are counting against MyISAM
Bad News if you are counting against InnoDB
Good News
-
For MyISAM
Just use either
SELECT table_rows FROM information_schema.tables WHERE table_schema='given db
name' and
MySql table update/difference
I have good news and bad news for you when it comes to MySQL 5.x.
Good News if you are counting against MyISAM
Bad News if you are counting against InnoDB
Good News
-
For MyISAM
Just use either
SELECT table_rows FROM information_schema.tables WHERE
, 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