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 dbpops
Hi all,
I recently had cause to drop and re-create a merge table that maps 80 or so
tables (I'd added an index to all the tables whilst they were mapped, so
causing me to get incorrect results. Duh!).
However, upon re-creating it, I find that I'm now not getting any results
back (or only one or
