On 1/28/03 12:26 PM, "Christopher Lyon" <[EMAIL PROTECTED]> wrote:
> I do have a timestamp field would I be better off using that? Granted it
> might not be the same amount of rows every time but how would that work?
>
>
> Select * from tbl_name where TIMESTAMP ( ) -3 hours;
>
Well, that is not what you asked for you just wanted to get the last N
records inserted into the database which is different from what you asked
now. Your original question is best answered with having an autoincrement
field in your table and do a:
SELECT field........ FROM table WHERE whatever = don'tknow
ORDER BY autoincrement_field DESC LIMIT N;
Using the timestamp field to retrive all records inserted within the last n
years/months/weeks/days/hours/minutes/second requires some string conversion
of the timestamp. Your best bet in that case is to look into the Date and
Time Functions:
Check comments also!
<http://www.mysql.com/doc/en/DATETIME.html>
<http://www.mysql.com/doc/en/Date_and_time_functions.html>
After reading through the excellent documentation it should be rather
straight forward how to do it.
Hth/h
<SQL, QUERY, TABLE>
P.s. I also strongly recommend to keep the discussion on the list for your
benefit (there are much better experts on the mysql list than me) but also
for the benefit of others with a similar problem (although there is a rather
big lag from posting to appearing on the list). The list archives also
getting way to little attention.
>
>> -----Original Message-----
>> From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, January 28, 2003 11:50 AM
>> To: Christopher Lyon; MySQL Mailinglist
>> Subject: Re: sql query using select and row functions
>>
>> On 1/28/03 8:26 AM, "Christopher Lyon" <[EMAIL PROTECTED]> wrote:
>>
>>> I am trying to do an sql query and am trying to select the last x
> rows
>>> from the database. I see the limit function but that seems like that
> is
>>> from the first row down. I want to start from the last row to the
> first
>>> row. So, selecting the last 5 rows for instance? Can this be done?
>>
>> The easiest way is probably to add an ORDER BY field DESC into your
> SQL
>> statement. If you use an autoincrement field you could use that
> otherwise
>> add a field and make it TIMESTAMP.
>>
>> Hth/h
>>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
