Chris wrote:
Tim McGeary wrote:
Stut wrote:
Ok, so I did the recommended process of:
mysql UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
- WHERE Host = 'some_host' AND User = 'some_user';
mysql FLUSH PRIVILEGES;
This allows the CLI script to run successfully, but the web php
I am trying to set an index on a field in my table, but am getting the
following error:
BLOB column 'ReadBy' used in key specification without a key length
The fieldtype is blob, though I get the same error whether blob or text, or
the medium and long versions of each. My first
You can't use that column type as an index because it's variable length.
Make it a varchar or something that's definite to index it.
-Micah
On 02/09/2007 03:56 PM, John Pillion wrote:
I am trying to set an index on a field in my table, but am getting the
following error:
BLOB column
Micah,
You can't use that column type as an index because it's variable length.
Makes sense.
Make it a varchar or something that's definite to index it.
It is possible the value stored can reach up to about 2k characters, which
is too long for a varchar type. Any recommendations as to
Perhaps I should of spoke more exactly. In MySQL 5.0 you can index
these, but the maximum index length is limted by the storage engine. So
you have to be specific as to how you index these columns.
The deal is that with large column fields making an index of several
thousand characters (for