-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, all --
...and then David T-G said... % ... % hashsum tinyblob not null , # hash of the card: have we seen this one? % index (hashsum) # for quick lookups ... % ERROR 1170 at line 49: BLOB column 'hash' used in key specification % without a key length Thanks so much to everyone who pointed out that I need hashsum tinyblob , index (hashsum(NN)) where NN is the number of chars to index (quite possibly less than the whole 255, and for me 32 -- the length of the md5 sum). It seems obvious now but obviously I missed it before :-) Thanks & HAND & HH mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EO4FGb7uCXufRwARAqgxAKC+BvhEx/jQAWeDY24JHMR4n+F0ywCfVkGc NrjEmbfWvkN18kIIpoKRV+Y= =w2dv -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
