ansaurus

Question

mysql query

Answer 1

+8 A:

I have changed the query so that Date column case matches exactly what you have in your query results.

select Date, count(Date)
from TABLE
where Date >= '2008-10-12' and Date <= '2008-10-13'
group by Date

You will need to change TABLE in the from clause, but everything else should be correct for your table.

edit:

I have a table with a similar structure and I changed a date column to be named 'Date'. The following worked for me.

mysql> select Date, count(Date) 
    from calendar_items 
    where date between '2008-12-12' and '2008-12-13' 
    group by Date;

+------------+-------------+
| Date       | count(Date) |
+------------+-------------+
| 2008-12-12 |          14 | 
| 2008-12-13 |           6 | 
+------------+-------------+
2 rows in set (0.00 sec)

mysql>

ewalshe 2009-01-07 09:10:53

Exactly how I'd do it (the second one that is) +1

Kezzer 2009-01-07 09:29:21

I had left the from clause out of the statement

ewalshe 2009-01-07 09:31:53

Don't try. Do. There is no try.

paxdiablo 2009-01-07 09:55:08

@Pax - I'm Irish. We disguise a command as a suggestion. :)

ewalshe 2009-01-08 00:06:01

Answer 2

A:

Hi ewalshe, The query is not working. thanks

2009-01-07 09:13:53

Look at Riho's answer or my updated one

ewalshe 2009-01-07 09:21:47

Please delete this, it should have been a comment to ewalshes answer.

paxdiablo 2009-01-07 09:34:13

Answer 3

+3 A:

Shouldn't it be:

select date, count(date) where date >= '2008-10-12' and date <= '2008-10-13' group by date

Riho 2009-01-07 09:15:19

Or see ewalshe's BETWEEN statement, but this would do it too.

Kezzer 2009-01-07 09:28:47

Answer 4

A:

Hi, Please take a look for fetching records per day..you can use like this---> SELECT something FROM tbl_name WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;

2009-01-07 09:16:26

Answer 5

A:

Hi ewalshe, I have tried the another query given by you, But the following error is displayed -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where date between '2008-10-12' and '2008-10-13' group by count(date)' at line 2

2009-01-07 09:18:59

change the group by to GROUP BY Date

ewalshe 2009-01-07 09:23:36

Answer 6

A:

Regarding your syntax error: As "date" is a reserved term in mysql, u have to escape it in your queries.

With this in mind ewalshes query should work:

select `Date`, count(`Date`)
from TABLENAME
where `Date` between '2008-10-12' and '2008-10-13'
group by `Date`

Karsten 2009-01-07 09:27:45

Answer 7

A:

Hi kartsten.

Even your query is not working Pls this query is urgent for me

2009-01-07 09:29:25

what exactly is the error message?

Karsten 2009-01-07 09:30:52

Answer 8

A:

Hi, anybody can help me

2009-01-07 09:44:13

I have updated the query

ewalshe 2009-01-07 10:10:25

Answer 9

A:

I'd try this:

SELECT count( * ) , date( `date` )
FROM `myTableName`
GROUP BY date( `date` )

(Tested on MySql 4.1)

Rowland Shaw 2009-01-07 13:45:31

ansaurus

tags:

views:

answers:

mysql query

related questions