List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:June 14 2010 10:37pm
Subject:RE: list rows with no recent updates
View as plain text  
Easy enough to rectify....

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

ALTER TABLE `tbl_xyz` ADD COLUMN `updated_on` TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `prod_id`;

Personally I put a 'created_on' and an 'updated_on' column for mostly every
table I create.

3000 rows is nothing. A mere blink of an eye to mySQL. The database I'm
using is almost a Billion (yes, with a B, and I mean a good ol' USA 10^9
Billion, not that goofy long scale 10^12 "Billion"*) rows and 90GB. So
don't worry about it. Plus it's stored internally as an integer (timestamp)


*http://en.wikipedia.org/wiki/Long_and_short_scales

> -----Original Message-----
> From: MadTh [mailto:madan.feedback@stripped] 
> Sent: Monday, June 14, 2010 2:23 PM
> To: mysql@stripped
> Subject: Re: list rows with no recent updates
> 
> Hi,
> 
> 
> Thank you all for your prompt response. Unfortunately 
> timestamp  file isn;t
> there, so I will find some other way to do it.
> 
> Seems timestamp  is a valuable field ( unless you want to 
> save resource on
> generating timestamps on a very busy table).
> 
> 
> 
> 
> 
> 
> Thanks
> 

Thread
list rows with no recent updatesMadTh14 Jun
  • RE: list rows with no recent updatesDaevid Vincent14 Jun
  • Re: list rows with no recent updatesJim Lyons14 Jun
  • Re: list rows with no recent updatesMadTh14 Jun
    • RE: list rows with no recent updatesDaevid Vincent15 Jun
  • Re: list rows with no recent updatesAdam Alkins16 Jun