Professional Web Applications Themes

Log sql inserts and updates? - MySQL

On Sun, 10 Sep 2006 08:42:03 -0800, darius wrote:  You need a DBMS that has a journalling feature. MS-SQL does this, as does DB2. I've done it one DB2 on iSeries machines, but I can't think of why it wouldn't be possible on other systems. (I ended up with a very nice table that logged EVERY change to a table, including what program did it, under what user ID, and before and after images of the table record.) Note that this is not the kind of journaling that ext3 provides. However, for mysql, I think you'll probably have to build ...

  1. #1

    Default Re: Log sql inserts and updates?

    On Sun, 10 Sep 2006 08:42:03 -0800, darius wrote: 

    You need a DBMS that has a journalling feature. MS-SQL does this, as
    does DB2. I've done it one DB2 on iSeries machines, but I can't think of
    why it wouldn't be possible on other systems. (I ended up with a very
    nice table that logged EVERY change to a table, including what program
    did it, under what user ID, and before and after images of the table
    record.) Note that this is not the kind of journaling that ext3
    provides.

    However, for mysql, I think you'll probably have to build your own out
    of triggers.

    --
    Premature optimization is the root of all evil.
    -- Sir Tony Hoare
    Peter Guest

  2. #2

    Default Log sql inserts and updates?

    Is there a way to log sql inserts and updates (in a human readble form,
    e.g., sql statements) to a specific database for a specific time frame.
    I want to say "start logging now", allow some external process to use the
    db, then say "stop logging" and look at what was done to the db. thanks
    darius Guest

Similar Threads

  1. oracle slow updates and inserts coldfusion
    By fang in forum Coldfusion Database Access
    Replies: 3
    Last Post: October 31st, 03:19 PM
  2. SQL INSERTS in Dreamweaver ASP?
    By maryfranan in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: July 28th, 06:09 PM
  3. 1-to-Many Inserts
    By Fandomlife in forum Macromedia ColdFusion
    Replies: 3
    Last Post: March 29th, 09:15 PM
  4. need loop that INSERTS into same row
    By Greggg in forum Macromedia ColdFusion
    Replies: 2
    Last Post: March 21st, 01:21 PM
  5. Datagrids which allow inserts, updates, and deletions
    By Michael Tkachev in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: September 16th, 07:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139