Looks like you want to bring up something that doesn't have anything to do with the original question which is your perogative. But please don't compare MySQL with Oracle and mainstream SQL RDBMSs. Give us a break.
> -----Original Message----- > From: Andrew Houghton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 9:10 AM > To: Dave Morse > Cc: 'Paul DuBois'; 'Arul'; [EMAIL PROTECTED]; 'MySQL' > Subject: Re: SubQueries and Temp Tables > > > It makes sense to many, or most, I'd say. Oracle produces > clients in a > variety of languages. So does every major database vendor. There is > zero import in the difference between the languages a server > and client > are written in.. it's all a network protocol, for God's sake, so who > gives a damn? > > - a. > > Dave Morse wrote: > > NO - mine is a honest question. An "open source" server in C and a > > client in Java makes sense, I guess to some. > > > > > >>-----Original Message----- > >>From: Paul DuBois [mailto:[EMAIL PROTECTED]] > >>Sent: Wednesday, June 26, 2002 5:37 PM > >>To: Dave Morse; 'Arul'; [EMAIL PROTECTED] > >>Cc: 'MySQL' > >>Subject: RE: SubQueries and Temp Tables > >> > >> > >>At 7:16 -0700 6/26/02, Dave Morse wrote: > >> > >>>MySQL is barely an SQL database - it doesn't support much > >> > >>basic SQL 89 > >> > >>>functionality. Can any one throw some light on why professional SQL > >>>database developers want to use it for anything but simple file > >>>management? AND It is written in C as well so why do Java > developers > >>>use it? > >> > >>Given that the server is a separate program than Java developers > >>would write *clients* for, why would it matter in the least what > >>language the server is written in. > >> > >>You're trolling, right? > >> > >> > >>>Regards, > >>> > >>>Dave > >>> > >>> > >>>> -----Original Message----- > >>>> From: Arul [mailto:[EMAIL PROTECTED]] > >>>> Sent: Tuesday, June 25, 2002 9:05 PM > >>>> To: [EMAIL PROTECTED] > >>>> Cc: MySQL > >>>> Subject: SubQueries and Temp Tables > >>>> > >>>> > >>>> Hi All > >>>> > >>>> I am currently porting our application from Oracle to MySQL. > >>>> We have some subqueries in oracle which cannot be ported into > >>>> MySQL.We even > >>>> tried some joins which didnt work out.. > >>>> > >>>> So Could anyone throw some light on Temporary tables.Is this > >>>> the right way > >>>> to do it.. > >>>> > >>>> Since our main query is dependent on the inner query we > >>>> thought we could > >>>> run > >>>> the inner queryfirst and create a temp table.Then we could > >>>> have a join > >>>> between the main table and the inner table. > >>>> > >>>> Is this advisable.. > >>>> > >>>> Any other better options? > >>>> > >>>> Regards, > >>>> -Arul > >>>> > >>>> > >>>> > >>>> > >>> > >>------------------------------------------------------------ > --------- > >> > >>>> Please check > >>>> "http://www.mysql.com/Manual_chapter/manual> _toc.html" before > >>>> > >>>> posting. To request this thread, e-mail > >>>> [EMAIL PROTECTED] > >>>> > >>>> To unsubscribe, send a message to the address shown in the > >>>> List-Unsubscribe header of this message. If you cannot see it, > >>>> e-mail [EMAIL PROTECTED] instead. > >>>> > >>> > >>> > >>> > >>>----------------------------------------------------------- > ---------- > >>>Before posting, please check: > >>> http://www.mysql.com/manual.php (the manual) > >>> http://lists.mysql.com/ (the list archive) > >>> > >>>To request this thread, e-mail <[EMAIL PROTECTED]> > >>>To unsubscribe, e-mail > >> > >><[EMAIL PROTECTED]> > >> > >>>Trouble unsubscribing? Try: > >> > >>http://lists.mysql.com/php/unsubscribe.php > >> > >> > > > > > > > > > > > --------------------------------------------------------------------- > > Please check > "http://www.mysql.com/Manual_chapter/manual> _toc.html" before > > > posting. To request this thread, e-mail > [EMAIL PROTECTED] > > > > To unsubscribe, send a message to the address shown in the > > List-Unsubscribe header of this message. If you cannot see it, > > e-mail [EMAIL PROTECTED] instead. > > > > > > > > > > --------------------------------------------------------------------- > Please check > "http://www.mysql.com/Manual_chapter/manual> _toc.html" before > > posting. To request this thread, e-mail > [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
