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 ?

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.

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 :)

I believe the InnoDB logs have that, if thats the tabletype you're using

InnoDB does have this feature and is free.

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.

I would think cost would be the #1 deterrant to Oracle :1orglaugh

Edit, misread post...

To answer the real question :) ; no, MySQL does not have that functionality, at least for the INNODB engine.

Yes I am using InnoDB currently....I will try to investigate more on this then....maybe I missed it in the docs

I'd never use Oracle personally :)

I tried PostgreSQL once few years back though, but what a disaster that was...