From: Stewart Smith Date: February 16 2010 6:48am Subject: Re: Getting handler of a table List-Archive: http://lists.mysql.com/internals/37711 Message-Id: <874olh4qx3.fsf@willster.local.flamingspork.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii On Sat, 13 Feb 2010 21:47:37 +0100, Merve Soner wrote: > I am trying to implement an automatic insert function inside MySQL. In > other words, when a SELECT query is run on the first table the result > of this query should be written to another table. sounds like you're trying to create an audit log of who is accessing what? If you hook into the handler calls, you'll get a bunch of unneeded rows taht would then be eliminated during query execution (think of a WHERE condition on a full table scan). -- Stewart Smith