I don't think you can use a blob or text column as a key/index. In fact,
to use it in a where statement you have to use a substring of the blob
AFAIR. It's in the manual, ALT-F for "blob" in the toc..
"John P. Looney" wrote:
>> On Tue, Apr 11, 2000 at 01:40:44PM +0100, Colm Buckley mentioned:
> > > Ack. How do I add a user to Mysql. I've a user;
> > >
> > > mysql> use mysql;
> > > mysql> select User,Host,Password from user where User = 'xenocide';
> > > [...]
> > > xena  mysql -u username -p
> > > Enter password: <-- I put in testpass
> > > ERROR 1045: Access denied for user: 'username at localhost' (Using password: YES)
> > >
> > > Any idea what could be wrong ?
> > 'mysqladmin reload' to reload the mysql users database.
>> Better yet! For bonus points, you could try tell me why this happens:
>> mysql> create table pixmaps (id int not null primary key, url text not null, owner char(50), index pixmap_idx(id,url));
> ERROR 1073: BLOB column 'url' can't be used in key specification with the used table type
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!