[thelist] mySQL- how to test if table contains data

[Ben Phillips]

> Would it be possible to "GROUP BY " day, when the date-format is in
> Unix-time (sec since 1970) ?

you can do this:

select ... ,TO_DAYS(timestamp) as date_day where ... group by date_day

i think? i know that works with a mysql timestamp - don't know if it works
with a unix timestamp... can anyone clarify?

benji.
inchima.com