Why did this not work?
mysql> select cdate,hour(ctime) as hr, count(distinct sName) from dbpopsj1
where hour(ctime) = 0 group by cdate, hr order by cdate, hr;
ERROR 1032: Can't find record in 'dbpopsj1'
While this did work!
mysql> select cdate,hour(ctime) as hr, count(sName) from dbpopsj1
where hour(ctime) = 0 group by cdate, hr order by cdate, hr;
+------------+------+--------------+
| cdate | hr | count(sName) |
+------------+------+--------------+
| 2001-05-21 | 0 | 256078 |
+------------+------+--------------+
1 row in set (35.74 sec)
And this worked and had to read thru all records and sort them!
select * from dbpopsj1 where sIpa="24.13.105.71" order by ctime limit 50;
----- this worked .... display not pertinent.
This table is a merge table of 4 tables.
Also the first query works when I called any of the base tables;
---------------------------------------------------------------------
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
