From: Brown, Charles (CBrownBMI.com)
Date: Tue Mar 13 2007 - 14:26:51 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello Dan. Try it and see if you can:

mysql> create index indx101 on tab101(min(c1),c2) ;

Answer: Its not supported.

-----Original Message-----
From: Dan Nelson [mailto:dnelsonallantgroup.com]
Sent: Tuesday, March 13, 2007 9:10 AM
To: Ananda Kumar
Cc: mysqllists.mysql.com
Subject: Re: function based index

In the last episode (Mar 13), Ananda Kumar said:
> Is it possible to create function based index in mysql as available
> in oracle. Please point me to any documentation on this.

Sorry; mysql doesn't have function-based indexes. The closest you can
get in mysql is if you add another column and an UPDATE trigger that
populates it with the results of your function, then index that column.

--
        Dan Nelson
        dnelsonallantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=cbrownbmi.com

********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]