[ILUG] MySQL

[John P. Looney]

On Tue, Apr 11, 2000 at 02:16:29PM +0100, adam beecher mentioned:
> > 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..
> Depends on the version. If it's >= 3.23.2, you can use a BLOB or TEXT as an
> index:
> http://www.mysql.com/Manual_chapter/manual_Reference.html#BLOB
> Does that solve it? :)

 As if I'm gonna do that any time soon. Mutter. I can live with URL's
being less than 256 chars, for the time being, I suppose ;)

 I notice that the MySQL manual says "References is understood, but not
supported" - so, when I want to do something like;

 create table skin (id int not null primary key, texture_id references textures(id), create_id references samples(id), destroy_id references samples(id), normal_id references samples(id), colour char (7), skin_type ENUM('texture','colour')); 

 What's the story ?

Kate

-- 
"The fool must be beaten with a stick, for an intelligent person 
the merest hint is sufficient"                -- Zen Master Greg