Donncha O Caoimh
donncha.ocaoimh at tradesignals.com
Tue Apr 11 14:01:57 IST 2000
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
More information about the ILUG