Re: FW: Join based upon LIKE

2011-04-29 Thread Hal�sz S�ndor
2011/04/28 15:28 -0400, Jerry Schwartz No takers? And this is not real taking, because the algorithm of which I am thinking, the edit-distance (Levens(h)tein-distance) algorithm costs too much for you (see the Wikipedia entry). The obvious implementation takes as many steps as

RE: ERROR 2006 (HY000)

2011-04-29 Thread Jerry Schwartz
>-Original Message- >From: Larry Martell [mailto:larry.mart...@gmail.com] >Sent: Friday, April 29, 2011 5:31 PM >To: Jerry Schwartz >Cc: mysql mailing list >Subject: Re: ERROR 2006 (HY000) > >On Fri, Apr 29, 2011 at 3:23 PM, Jerry Schwartz wrote: >> I'm getting >> >> ERROR 2006 (HY000) at

Re: ERROR 2006 (HY000)

2011-04-29 Thread Larry Martell
On Fri, Apr 29, 2011 at 3:23 PM, Jerry Schwartz wrote: > I'm getting > > ERROR 2006 (HY000) at line 10: MySQL server has gone away > > while trying to do an insert through the MySQL CLI. Our database is so small > that I haven't gotten around to doing any tuning, so this came out of the > blue. I'

ERROR 2006 (HY000)

2011-04-29 Thread Jerry Schwartz
I'm getting ERROR 2006 (HY000) at line 10: MySQL server has gone away while trying to do an insert through the MySQL CLI. Our database is so small that I haven't gotten around to doing any tuning, so this came out of the blue. I'm not quite sure where to start. Here's what things look like at

RE: Join based upon LIKE

2011-04-29 Thread Jerry Schwartz
>-Original Message- >From: Jim McNeely [mailto:j...@newcenturydata.com] >Sent: Thursday, April 28, 2011 6:43 PM >To: Jerry Schwartz >Subject: Re: Join based upon LIKE > >It just smells wrong, a nicer system would have you joining on ID's of some >kind so that spelling wouldn't matter. I don

RE: Join based upon LIKE

2011-04-29 Thread Jerry Schwartz
>-Original Message- >From: Johan De Meersman [mailto:vegiv...@tuxera.be] >Sent: Friday, April 29, 2011 5:56 AM >To: Jerry Schwartz >Cc: mysql mailing list >Subject: Re: Join based upon LIKE > > >- Original Message - >> From: "Jerry Schwartz" >> >> [JS] This isn't the only place I h

Re: Join based upon LIKE

2011-04-29 Thread Johan De Meersman
- Original Message - > From: "Jerry Schwartz" > > [JS] This isn't the only place I have to deal with fuzzy data. :-( > Discretion prohibits further comment. Heh. What you *really* need, is a LART. Preferably one of the spiked variety. > A full-text index would work if I were only looki