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
