Yes and no. The binary log is a long list of all changes to the system, so if that's enabled you can get what was done. My binary log (on 4.1.19) shows the query thread, but not the user/host that did the change. So it might be difficult to implement an "undo".
Also, "delete from table1" does not actually tell you what the old values were, nor does "update table1 set bar=baz where yar=yaz". So you can tell what changed, but not necessarily how to change it back. Hope that helps a bit. -Sheeri On 5/30/06, Karl Berry <[EMAIL PROTECTED]> wrote:
(Excuse the beginner's question, but I couldn't find an answer in the documentation or in searching online. Please cc me on replies if possible.) Does mysql have a way to report on the last committed change to the database? I gather there is no undo in databases, in the sense of an editing undo, and I gather rollback applies before a final commit is done. I'm interested in the simpler case where the user makes a change and then says "oops, I think I made a mistake". Thus, having a way to review what was just done (so the user can resubmit if necessary). If there is nothing at the database level, of course I can (attempt to) keep track in my application and report it that way. I just thought it would be easier and more reliable to get the info from the db, if it's available. Thanks, Karl ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]