11 messages in com.mysql.lists.mysqlRe: SELECTing last occurences from a ...
FromSent OnAttachments
Mateusz01 Jun 2003 12:37 
Becoming Digital01 Jun 2003 15:28 
Mateusz01 Jun 2003 16:17 
Martin Gainty01 Jun 2003 16:38 
Mateusz01 Jun 2003 16:55 
Nils Valentin01 Jun 2003 19:09 
Nils Valentin01 Jun 2003 19:15 
Becoming Digital01 Jun 2003 19:16 
Becoming Digital01 Jun 2003 19:17 
Gordon01 Jun 2003 21:49 
Mateusz02 Jun 2003 01:38 
Subject:Re: SELECTing last occurences from a table
From:Nils Valentin (ni@knowd.co.jp)
Date:06/01/2003 07:15:55 PM
List:com.mysql.lists.mysql

I believe you are at minimum talking about a subselect command here.

I am just about to get the idea what you really want. You want to request all updated prices f.e. to show a pricelist with the newest prices.

I guess thats to high for me to reach right now - but definitely interesting ;-)

Best regards

Nils Valentin Tokyo/Japan

2003年 6月 2日 月曜日 08:55、Mateusz さんは書きました:

SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC

LIMIT

1; COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date

that

the record was inserted

This would only select one row (the most recent). I need a set of rows, one for _each_ type of food (one and only one for tomatoes, one and only one for potatoes and so on).

Mateusz Uzdowski

-- ================================================ Valentin Nils Internet Technology

E-Mail: ni@knowd.co.jp URL: http://www.knowd.co.jp ================================================