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
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_lengthparameter to mysql. A workaround for most cases is to use a substring:
SELECT DISTINCT LEFT(blob,2048) FROM table.
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.