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
>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 ?
"The fool must be beaten with a stick, for an intelligent person
the merest hint is sufficient" -- Zen Master Greg
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!