List:General Discussion« Previous MessageNext Message »
From:Pau Marc Munoz Torres Date:November 13 2007 3:12pm
Subject:Re: indexing tables using my owns functions
View as plain text  
mmmm, as far as i can see, from mysql 5.0 and upper it is possible create
index using functions.

http://www.faqs.org/docs/ppbook/r24254.htm

But i keep having problems with the exemple from the link. Is there any bug
in  mysql 5.0.24a-log?

2007/11/13, Martijn Tonies <m.tonies@stripped>:

>mysql> create index AA on  precalc (IDR(P1,P4,P6,P7,P9,'HLA-DRB13'));
> >
> >But i Get the following error:
> >
> >ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual
> >that corresponds to your MySQL server version for the right syntax to use
> >near ''P1','P4','P6','P7','P9','HLA-DRB13'))' at line 1
> >
> >Some one knows where is the error?
>
> As far as I can see (
> http://dev.mysql.com/doc/refman/5.0/en/create-index.html )
> you can only use columns, not a function.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
> &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de  Biotecnologia   i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc.munoz@stripped

Thread
indexing tables using my owns functionsPau Marc Munoz Torres13 Nov
  • indexing tables using my owns functionsPau Marc Munoz Torres13 Nov
Re: indexing tables using my owns functionsMartijn Tonies13 Nov
  • Re: indexing tables using my owns functionsPau Marc Munoz Torres13 Nov
Re: indexing tables using my owns functionsMartijn Tonies13 Nov