Quick MySQL question

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Varius
    Confirmed User
    • Jun 2004
    • 6890
    #1

    Quick MySQL question

    I am just curious, haven't seen anything in the docs about this, but does MySQL have an internal timestamp for each record (to know when it was last modified) ?

    I know Oracle has this as an 'audit' feature.

    Anyone know if MySQL has something equivalent ?
    Skype variuscr - Email varius AT gmail
    Tags: None
    • Tempest
      Too lazy to set a custom title
      • May 2004
      • 10217
      #2
      I believe you have to add the field TIMESTAMP in order to get that and it updates every time the row is modified..

        Comment

        • Varius
          Confirmed User
          • Jun 2004
          • 6890
          #3
          Originally posted by Tempest
          I believe you have to add the field TIMESTAMP in order to get that and it updates every time the row is modified..
          yeah, you can do that....I was just curious if mysql had any automatic/invisible tracking of modifications that could be accessed.
          Skype variuscr - Email varius AT gmail

            Comment

            • Tempest
              Too lazy to set a custom title
              • May 2004
              • 10217
              #4
              Originally posted by Varius
              yeah, you can do that....I was just curious if mysql had any automatic/invisible tracking of modifications that could be accessed.
              I don't think so. mySQL and the like are more barebones roll your own compared to something like oracle.

                Comment

                • Varius
                  Confirmed User
                  • Jun 2004
                  • 6890
                  #5
                  Originally posted by Tempest
                  I don't think so. mySQL and the like are more barebones roll your own compared to something like oracle.
                  ok, I figured as much...well thanks for the info
                  Skype variuscr - Email varius AT gmail

                    Comment

                    • kernelpanic
                      Too lazy to set a custom title
                      • Jan 2005
                      • 2961
                      #6
                      I believe the InnoDB logs have that, if thats the tabletype you're using


                      ZangoCash - Turn Your Traffic Into Ca$h.
                      $.40 Per Install - No Tier

                        Comment

                        • V_RocKs
                          Damn Right I Kiss Ass!
                          • Nov 2003
                          • 32451
                          #7
                          InnoDB does have this feature and is free.

                            Comment

                            • mrkris
                              Confirmed User
                              • May 2005
                              • 2737
                              #8
                              Oracle is to bloated

                              I would not recommend Oracle to anyone not strong with database design. Very complicated setup. MySQL can handle more than enough for the average sites and all.

                              PHP-MySQL-Rails | ICQ: 342500546

                                Comment

                                • kernelpanic
                                  Too lazy to set a custom title
                                  • Jan 2005
                                  • 2961
                                  #9
                                  Originally posted by mrkris
                                  I would not recommend Oracle to anyone not strong with database design. Very complicated setup. MySQL can handle more than enough for the average sites and all.
                                  I would think cost would be the #1 deterrant to Oracle


                                  ZangoCash - Turn Your Traffic Into Ca$h.
                                  $.40 Per Install - No Tier

                                    Comment

                                    • vending_machine
                                      Confirmed User
                                      • Jun 2002
                                      • 1070
                                      #10
                                      Edit, misread post...

                                      To answer the real question ; no, MySQL does not have that functionality, at least for the INNODB engine.
                                      Last edited by vending_machine; 06-10-2005, 02:19 PM.

                                        Comment

                                        • Varius
                                          Confirmed User
                                          • Jun 2004
                                          • 6890
                                          #11
                                          Originally posted by kernelpanic
                                          I believe the InnoDB logs have that, if thats the tabletype you're using
                                          Yes I am using InnoDB currently....I will try to investigate more on this then....maybe I missed it in the docs
                                          Skype variuscr - Email varius AT gmail

                                            Comment

                                            • Varius
                                              Confirmed User
                                              • Jun 2004
                                              • 6890
                                              #12
                                              Originally posted by mrkris
                                              I would not recommend Oracle to anyone not strong with database design. Very complicated setup. MySQL can handle more than enough for the average sites and all.
                                              I'd never use Oracle personally

                                              I tried PostgreSQL once few years back though, but what a disaster that was...
                                              Skype variuscr - Email varius AT gmail

                                                Comment

                                                Previous template Next
                                                Working...