Re: Tough queries

2005-06-21 Thread mark warren bracher
David Legault wrote: Thanks for the reply, but I think you misinterpreted what I'm looking for here. For the first query I want to be able to get a row record of (in one query possibly) team_name for first team (team_id1) team_name for second team (team_id2) and each of these team points

[4.0] latin1 accented characters and fulltext

2004-03-16 Thread mark warren bracher
I've been playing around with fulltext searching in 4.0, and I ran into the following weirdness with accented characters. | version | 4.0.14 | character_set | latin1 in my entire

Re: [4.1.1] 1062 errors on non-unique index during data load

2004-02-23 Thread mark warren bracher
Victoria Reznichenko wrote: [snip] Could you create repeatable test case (table structure (output of SHOW CREATE TABLE) and text file with data that will be enough to reproduce the above behavior)? I'll see if I can get something generic to error out. there's pretty much no way I'll be able to

Re: [4.1.1] 1062 errors on non-unique index during data load

2004-02-20 Thread mark warren bracher
to be seen whether this will crop back up during incremental update of the already filled (and indexed) table, but I've got a good bit of coding to do before I'll have an answer to that question... - mark mark warren bracher wrote: In the last few days I've been doing some prototyping on mysql

[4.1.1] 1062 errors on non-unique index during data load

2004-02-13 Thread mark warren bracher
In the last few days I've been doing some prototyping on mysql 4.1.1 (mainly because I want fulltext indexes against utf-8 data). I have a table, artists_search_A, in which I want to load ~100K records. My load process will routinely load 14783 records successfully. After 14783 inserts, any