kindly provide me with ans as quickly as possible
views:
16answers:
1
Q:
how to fetch the most recent bunch of data entered out of thousands of data present in a database
A:
You have an entered timestamp column, right?
select * from table order by entered desc;
Greg Hewgill
2010-02-18 07:38:53
And use an update- and/or insert-trigger to automatically update the 'entered' column
Patrick
2010-02-18 07:41:42
In MySQL you have a timestamp type of column, with which you don't have to use any triggers.
Vanco
2010-06-06 07:24:55