Do you have a question? Post it now! No Registration Necessary. Now with pictures!
May 28, 2005, 5:56 am
rate this thread
suppose a hypothetical table called 'table' with one field called 'field' of
an arbitrary type.
select count(*) from table where field='value' group by field
produces no rows when run under the latest mysql. without "group by" it
produces 1 row.
is this according to the SQL standard or is this just a coincidence? in
other words, can i rely on this behaviour to deduce that there are no fields
with value 'value' in 'table'?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum