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 time that i query the database I store the table situation in another table, called TABLE_TEMP, so the operation of difference detection is TABLE_DIFERENCE = TABLE - TABLE_TEMP. How can I do this query? The problem that I have is that I don't know the structure of the table and I want to create a program with can be used for all types of data and tables. Please help me. Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org