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
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
. I think it's not a easy query (or set of queries), but I
want to create one for this goal.
However thanks for the hint about the difference between COUNT(1) and COUNT(*)!
Thanks.
-Original Message-
From: Rolando Edwards
Sent: Wednesday, August 05, 2009 23:12:09
Subject: RE: Ho
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='' and table_name='';
Or
SE
