Re: Left Join Help

2006-06-24 Thread Daniel McQuay
> DB engine. > > The query needs to pull in about 50,000 results. > > Does anyone see a way to optimize this query or rewrite it so it doesn't cause > a huge system load? > > Thank you, > > -- No virus found in this outgoing message. Checked by AVG Free Edition. V

Re: Exclusion Query

2006-06-22 Thread Daniel McQuay
7;L0%') and (fld_archived = '0')) The problem is it is not returning the correct information. -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org H: 814.825.0847 M: 814-341-6233

Re: [mysql] Attention List

2006-06-16 Thread Daniel McQuay
i took it more as a grain of pepper and just wanted to warn y'all of the impending virus attack that may or may not be sent around. thanks for the break down though. On 6/16/06, Chris White <[EMAIL PROTECTED]> wrote: On Friday 16 June 2006 03:01 pm, Daniel McQuay wrote: > hel

[mysql] Attention List

2006-06-16 Thread Daniel McQuay
The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment. MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel McQuay [EMAIL PROTECTED] boxster.homel

Re: Take my name off your list !!

2006-05-31 Thread Daniel McQuay
- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: i'm at a complete loss?

2006-05-29 Thread Daniel McQuay
ent --- -- *From:* Daniel McQuay [mailto:[EMAIL PROTECTED] *Sent:* Tuesday, 30 May 2006 10:39 AM *To:* Logan, David (SST - Adelaide) *Cc:* David Griffiths; mysql@lists.mysql.com *Subject:* Re: i'm at

Re: i'm at a complete loss?

2006-05-29 Thread Daniel McQuay
ide SA 5001 Australia invent ----------- -Original Message- From: Daniel McQuay [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 May 2006 10:20 AM Cc: David Griffiths; mysql@lists.mysql

Re: i'm at a complete loss?

2006-05-29 Thread Daniel McQuay
resolve to the problem. FYI I had seen that error before on my machine and tried to solve, but with no luck. On 5/29/06, Daniel McQuay <[EMAIL PROTECTED]> wrote: Yeah when I ran it the first time I get this message: boxster# /usr/local/bin/mysql_install_db --user=mysql Installing all prep

Re: i'm at a complete loss?

2006-05-29 Thread Daniel McQuay
Adelaide SA 5001 Australia invent ------- -Original Message- From: Daniel McQuay [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 May 2006 9:53 AM To: David Griffiths Cc: mysql@lists.mysql.com

Re: i'm at a complete loss?

2006-05-29 Thread Daniel McQuay
7;, 'mysql', password(mysql)); Don't forget to do a "flush privileges;" afterwards (again, no quotes); The mysql schema is thoroughly (but dryly) documented @ http://dev.mysql.com David Daniel McQuay wrote: > Thanks Greg, I did try that here is what happened. > >

Re: i'm at a complete loss?

2006-05-29 Thread Daniel McQuay
one has 'em. On 5/29/06, Greg Maruszeczka <[EMAIL PROTECTED]> wrote: On Sun, 28 May 2006 20:17:53 -0400 "Daniel McQuay" <[EMAIL PROTECTED]> wrote: > Hello list, > > I just installed MySQL on my FreeBSD box here at home and am having a > few problems with pr

i'm at a complete loss?

2006-05-28 Thread Daniel McQuay
this guide here http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing seemed to go well but like I said I keep getting this error. Is there something else I should do? Any help on this would be MUCH appreciated. Thanks in advance, -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org 814.825.0847