Re: about mysqld

2005-12-01 Thread Matt Monaco
I am having similar issues. I moved a copy of mysqld_safe to init.d and removed the old startup script, this had the effect of lowering the number of processes from about 30 something to 7 or 8. However mysqld_safe now appears as a subprocess of rc and under mysqld_safe is mysqld and under t

Re: Windows - logging into MySQL

2005-11-30 Thread Matt Monaco
Well stupid questions are usually responded to with simple answers like rtfm. You'd think you'd be able to at least be able to install a version of the daemon that's still supported before you get into advanced topics like mysql -h ""Beauford"" <[EMAIL PROTECTED]> wrote in message news:[EMAI

Re: comma-separated JOINS

2005-11-29 Thread Matt Monaco
guous but is the only way to declare an > outer JOIN with MySQL. When you use the explicit JOIN syntax, you are also > less likely to form unintentional Cartesian products which can absolutely > clobber a query's performance. > > Shawn Green > Database Administrator > Uni

Re: comma-separated JOINS

2005-11-28 Thread Matt Monaco
l be used? > > There's no ON clause for a join specified by a WHERE clause, and that's > one reason specifiying joins with JOIN ... ON .. is almost always > preferable--it entirely disambiguates the join for the writer, readers, > and those others who later will have to divin

Re: Why are posts to this list showing up in my inbox?

2005-11-28 Thread Matt Monaco
68 665 - Mobile +61 8 8408 4259 - Fax -----Original Message- From: Matt Monaco [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 November 2005 1:40 PM To: mysql@lists.mysql.com Subject: Why are posts to this list showing up in my inbox? I am using outlook express to view this mailing list, I do not

Why are posts to this list showing up in my inbox?

2005-11-28 Thread Matt Monaco
I am using outlook express to view this mailing list, I do not need the posts actually mailed to my account, how can I address this? Thanks in advance, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE

comma-separated JOINS

2005-11-28 Thread Matt Monaco
When using JOINS by the simply supplying a comma separated list of tables in the FROM clause, is the ON argument normally associated with a join intended to be addressed in the WHERE clause, or should ON still be used? // Comma separated join SELECT u.*, a.city FROM users u, addresses a WHERE u.id