Re: SubQueries and Temp Tables
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. >>>>>> >>>>> >>>>> >>>>>--
RE: SubQueries and Temp Tables
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
Re: SubQueries and Temp Tables
Dave, The language that the server is written in is irrelevant. Oracle, SQL Server, Sybase and most other databases are written in C and Java developers do business in them just fine. That's why JDBC is for. Many legacy systems are written in C, C++, or other language. That is another area where EJB shines, in frontending legacy systems with Java/JSP clients. The reason this makes sense to most is because this is how the real world works. I love writing in Java and don't want to go back to C/C++; but C/C++ makes sense for operating systems like Linux or db systems like MySQL. That isn't likely to change in the next 10-20 years, if ever. Even when 20Ghz+ machines come about and a "Java Linux" would be reasonable, the C version is already there and would still greatly outperform a Java version. The same is true for any of the database systems out there, including MySQL So bridges between these worlds is where the action is. Other people can best answer your objections to MySQL itself. For myself, I believe that it does support most of '89 but do wish it had Stored Procedures. Subselects are on the way. Foreign key support is coming, though I don't care for that much. The transactional tables covered the biggest objections I had. I am able to do "real" database applications with it as are many professional database developers. Cheers, Frank 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. - 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
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. > > > - 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
RE: SubQueries and Temp Tables
At 7:12 -0700 6/27/02, 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. I guess I'm not sure why it wouldn't make sense. If you're running a Web browser that's written in Java, do you require a Web server to be written in Java before you'll connect to it? > >> -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 >> >> - 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
RE: SubQueries and Temp Tables
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 > > - 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
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 - 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
Re: SubQueries and Temp Tables
It's hard to give a common suggestion which is suitable for all cases. We need to know the exact queries being executed. Arul wrote: > Agreed Ralf... > Not all SubQueries can be replaced by Joins.. > Thats why we have planned for Temp Tables.. > Any ideas on it.. > > > - Original Message - > From: "Ralf Narozny" <[EMAIL PROTECTED]> > To: "Arul" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > Sent: Wednesday, June 26, 2002 3:00 PM > Subject: Re: SubQueries and Temp Tables > > > >>Hiho hiho! >> >>Which joins could that be? I think most if not all subqueries should be >>replacable with joins. >> >>Greetings >> Ralf >> >>Arul wrote: >> >> >>>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? >>> >>> >>> >> >>-- >>Ralf Narozny >>Splendid Internet GmbH >>Skandinaviendamm 212, 24109 Kiel, Germany >>fon: +49 431 660 97 0, fax: +49 431 660 97 20 >>mailto:[EMAIL PROTECTED], http://www.splendid.de >> >> >> > > > > - > 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 > > > -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 - 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
RE: SubQueries and Temp Tables
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? 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
Re: SubQueries and Temp Tables
Agreed Ralf... Not all SubQueries can be replaced by Joins.. Thats why we have planned for Temp Tables.. Any ideas on it.. - Original Message - From: "Ralf Narozny" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 3:00 PM Subject: Re: SubQueries and Temp Tables > Hiho hiho! > > Which joins could that be? I think most if not all subqueries should be > replacable with joins. > > Greetings > Ralf > > Arul wrote: > > >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? > > > > > > > > -- > Ralf Narozny > Splendid Internet GmbH > Skandinaviendamm 212, 24109 Kiel, Germany > fon: +49 431 660 97 0, fax: +49 431 660 97 20 > mailto:[EMAIL PROTECTED], http://www.splendid.de > > > - 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
Re: SubQueries and Temp Tables
Hiho hiho! Which joins could that be? I think most if not all subqueries should be replacable with joins. Greetings Ralf Arul wrote: >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? > > > -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - 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
