You brought it up. You made the comparison. Give us a break. Dave Morse wrote:
>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 > > --------------------------------------------------------------------- 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
