List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:November 13 2007 2:38pm
Subject:Re: indexing tables using my owns functions
View as plain text  
>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

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