Re: JOIN, JOIN, JOIN

2012-08-22 Thread hsv
2012/08/22 17:38 -0400, Shawn Green MySQL does not have a simple OUTER JOIN command (some RDBMSes call this a FULL OUTER JOIN). What we do have is the option to include the OUTER keyword into our LEFT or RIGHT joins. For example, both of these are acceptable: LEFT OUTER JOIN LEFT JOIN

Re: Machine Learning

2012-08-22 Thread Garot Conklin
I am going to work up a visual diagram for this to better... visualize (LOL) the lay of the land. I will forward it when i have it completed then I hope we can continue the architectural discussion here!  Thanks -Garot   garotconk...@yahoo.com From: Garot Con

Re: help with correlated subquery

2012-08-22 Thread Shawn Green
Hello Martin, On 8/22/2012 8:30 AM, Martin Gainty wrote: assign realistic alias names OuterJoin should be called OuterJoin InnerJoin should be called InnerJoin Almost! MySQL does not have a simple OUTER JOIN command (some RDBMSes call this a FULL OUTER JOIN). What we do have is the option

RE: New Fast MySQL Compatible Server Released under the GPL License

2012-08-22 Thread Daevid Vincent
Well, considering that MySQL/Sun/Oracle can't even figure out how to reduce an ibdata1 file from ever-expanding after a decade (http://bugs.mysql.com/1341), it doesn't surprise me that parallel computing is a brain-stumper for them. :-\ Besides, I would suspect that Oracle would see this as one mo

Re: New Fast MySQL Compatible Server Released under the GPL License

2012-08-22 Thread Gael Martinez
On Wed, Aug 22, 2012 at 11:43 AM, Hiromichi Watari < hiromichiwat...@yahoo.com> wrote: > [..] > > Available at www.paralleluniverse-inc.com Hello Pardon my question on that one, but why wasn't the concept detailed in that white paper implemented into the core version of mysql or the percona vers

New Fast MySQL Compatible Server Released under the GPL License

2012-08-22 Thread Hiromichi Watari
Parallel Universe is an extension of MySQL server architecture, created to provide fast parallel query capability. Speed is achieved by processing tables in parallel, utilizing multi core/CPU of server hardware. Parallel Universe is released under the GPL license and fully compatible with MySQ

RE: help with correlated subquery

2012-08-22 Thread Rick James
The inner query has multiple rows because of wafer_id. The outer query then gives you multiple copies, hence screwing up the COUNT. Also, the AVG(AVG()) is mathematically incorrect unless the counts are identical. > -Original Message- > From: Larry Martell [mailto:larry.mart...@gmail.c

Re: user accounts using Active Directory

2012-08-22 Thread Ignacio Ocampo
Hi Aastha, I think that you can develop a Plugin to do it. Recently, I post a plugin that allow authenticate users through LDAP Server ( http://nafiux.com/blog/2012/08/16/mysql-ldap-authentication-plugin-clear-password-client-plugin/ ). More info about MySQL Authentication Plugins: http://dev.my

user accounts using Active Directory

2012-08-22 Thread Aastha
Hello, I want to create users and give access to different schema within the database. I also want to give them selective privileges to access the table in different schema. One way is to create users in MySQL and then grant with privileges. Is there any way to give them access to MySQL database

RE: help with correlated subquery

2012-08-22 Thread Martin Gainty
assign realistic alias names OuterJoin should be called OuterJoin InnerJoin should be called InnerJoin If you want only the most restricitive criteria that match resultsets from both select statements use INNER JOIN if you want all results from both resultsets (cartesian JOIN) use OUTER JOIN Fi