SELECT grp,COUNT(*) as c FROM table GROUP BY grp HAVING c > 1 instead of SELECT grp FROM table GROUP BY grp HAVING count(*) > 1
GROUP BY
or ORDER BY
or
DISTINCT
. Only the first max_sort_length
(default 1024)
are used when comparing blobs in these cases. This can be changed with
the -O max_sort_length
parameter to mysql. A workaround for most
cases is to use a substring: SELECT DISTINCT LEFT(blob,2048) FROM
table
.
bigint
or double
(both are
normally 64 bit long). It depends on the function which precision one
gets. The general rule is that bit functions are done with bigint
precision, IF, and ELT() with bigint or double precision and the rest
with double precision. One should try to avoid using bigger unsigned long
long values than 63 bits (9223372036854775807) for anything else than bit
fields!
SELECT * FROM table WHERE name = 'david '
For platform specific bugs see the sections about compiling and porting.
Go to the first, previous, next, last section, table of contents.