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:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 9:10 AM To: Ananda Kumar Cc: mysql@lists.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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ******************************************** 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
