Max number of 64 indices per table?

2007-01-26 Thread Horst Jäger
Hi everyone, the number of incices per table seems to be restricted to 64. Any way to change that? I'm using MySQL 5.0.27 . Thanks in advance Horst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Let mysql calculate levenshtein-distance

2005-11-14 Thread Horst Jäger
Hi, I have a nice little code snippet in pseudocode, which calculates the levenshtein-distance between 2 words. Is it possible to implement that code in mysql like in select word1,word2 from myTable order by dist(word1,word2 ) where dist is the function mentionend above which takes 2

Newbie: Ranking-Statement

2004-08-02 Thread Horst Jäger
Hi, suppose I've got a table RichMan with columns ID, Name, Bucks 1, 'John', 300 2, 'Joe', 700 3, 'Al', 400 4, 'Fred', 250 5, 'Jim', 480 and I sort them with respect to Bucks. Then John would be on the first place because he ist the richest, followed by 'Jim', etc. Now I'm looking for an