Tag Archives: aggregate-functions
MySQL GROUP BY UNIX TIMESTAMP
I’m trying to fetch a number of rows from a MySQL database and group them by the day they were posted.
End result I would like the following..
Monday
-Article 1
-Article 2
-Article 3
Tuesday
-Article 1
-Article 2… Continue reading
Tagged aggregate-functions, mysql, php
1 Comment
Running queries on tables with more than 1million rows in
I am indexing all the columns that I use in my Where / Order by, is there anything else I can do to speed the queries up?
The queries are very simple, like:
SELECT COUNT(*)
FROM TABLE
WHERE user =
Tagged aggregate-functions, mysql, php, sql
2 Comments
1 pages