|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
06-10-2005, 01:58 PM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Jun 2004
Location: New York, NY
Posts: 6,890
|
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 |
|
|
|
06-10-2005, 02:06 PM
|
#2 |
|
Too lazy to set a custom title
Industry Role:
Join Date: May 2004
Location: West Coast, Canada.
Posts: 10,217
|
I believe you have to add the field TIMESTAMP in order to get that and it updates every time the row is modified..
|
|
|
|
|
06-10-2005, 02:08 PM
|
#3 | |
|
Confirmed User
Industry Role:
Join Date: Jun 2004
Location: New York, NY
Posts: 6,890
|
Quote:
__________________
Skype variuscr - Email varius AT gmail |
|
|
|
|
|
06-10-2005, 02:16 PM
|
#4 | |
|
Too lazy to set a custom title
Industry Role:
Join Date: May 2004
Location: West Coast, Canada.
Posts: 10,217
|
Quote:
|
|
|
|
|
|
06-10-2005, 02:42 PM
|
#5 | |
|
Confirmed User
Industry Role:
Join Date: Jun 2004
Location: New York, NY
Posts: 6,890
|
Quote:
__________________
Skype variuscr - Email varius AT gmail |
|
|
|
|
|
06-10-2005, 02:45 PM
|
#6 |
|
Too lazy to set a custom title
Join Date: Jan 2005
Posts: 2,961
|
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 |
|
|
|
|
06-10-2005, 02:57 PM
|
#7 |
|
Damn Right I Kiss Ass!
Industry Role:
Join Date: Dec 2003
Location: Cowtown, USA
Posts: 32,409
|
InnoDB does have this feature and is free.
|
|
|
|
|
06-10-2005, 03:00 PM
|
#8 |
|
Confirmed User
Join Date: May 2005
Posts: 2,737
|
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 |
|
|
|
|
06-10-2005, 03:02 PM
|
#9 | |
|
Too lazy to set a custom title
Join Date: Jan 2005
Posts: 2,961
|
Quote:
__________________
ZangoCash - Turn Your Traffic Into Ca$h. $.40 Per Install - No Tier |
|
|
|
|
|
06-10-2005, 03:16 PM
|
#10 |
|
Confirmed User
Join Date: Jun 2002
Location: Seattle
Posts: 1,062
|
Edit, misread post...
To answer the real question ; no, MySQL does not have that functionality, at least for the INNODB engine. |
|
|
|
|
06-10-2005, 03:32 PM
|
#11 | |
|
Confirmed User
Industry Role:
Join Date: Jun 2004
Location: New York, NY
Posts: 6,890
|
Quote:
__________________
Skype variuscr - Email varius AT gmail |
|
|
|
|
|
06-10-2005, 03:32 PM
|
#12 | |
|
Confirmed User
Industry Role:
Join Date: Jun 2004
Location: New York, NY
Posts: 6,890
|
Quote:
I tried PostgreSQL once few years back though, but what a disaster that was...
__________________
Skype variuscr - Email varius AT gmail |
|
|
|
|
