MySQL Forums
Forum List  »  Newbie

query cannot retrieves all the records
Posted by: ordnas odrali
Date: May 05, 2005 06:31AM

Hello there,
I've got this problem, this query is used to create a combo wich display all months where at least a news is been submited (a kind of hostory menĂ¹), the fact is that it can display max the months wich correspond to the 107 record submited.

The query:
select date_format(data,"%b/%Y")as textMonth, month(data)as month,dayofmonth(data)as day,year(data)as year from archivio where category = "Rassegna Stampa" group by month

Just to be shure I've also tried the query above on mysql browser, and the result is the same.
Can you tell me if there's a kind of limit?
Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
query cannot retrieves all the records
May 05, 2005 06:31AM
May 05, 2005 07:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.