[ILUG] MySQL

[Donncha O Caoimh]

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..

Donncha.


"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 [0]  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