List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 27 2002 7:56pm
Subject:Re: SubQueries and Temp Tables
View as plain text  
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:aah@stripped] 
>>Sent: Thursday, June 27, 2002 9:10 AM
>>To: Dave Morse
>>Cc: 'Paul DuBois'; 'Arul'; java@stripped; '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:paul@stripped] 
>>>>Sent: Wednesday, June 26, 2002 5:37 PM
>>>>To: Dave Morse; 'Arul'; java@stripped
>>>>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:arulkumar@stripped]
>>>>>>Sent: Tuesday, June 25, 2002 9:05 PM
>>>>>>To: java@stripped
>>>>>>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
>>>>>>java-thread3890@stripped
>>>>>>
>>>>>>To unsubscribe, send a message to the address shown in the
>>>>>>List-Unsubscribe header of this message. If you cannot see it,
>>>>>>e-mail java-unsubscribe@stripped 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
> <mysql-thread113047@stripped>
>>>>>To unsubscribe, e-mail 
>>>>>
>>>><mysql-unsubscribe-paul=snake.net@stripped>
>>>>
>>>>>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 
>>>
>>java-thread3907@stripped
>>
>>>To unsubscribe, send a message to the address shown in the
>>>List-Unsubscribe header of this message. If you cannot see it,
>>>e-mail java-unsubscribe@stripped instead.
>>>
>>>
>>>
>>
>>
>>---------------------------------------------------------------------
>>Please check 
>>"http://www.mysql.com/Manual_chapter/manual> _toc.html" before
>>
>>posting. To request this thread, e-mail 
>>java-thread3911@stripped
>>
>>To unsubscribe, send a message to the address shown in the
>>List-Unsubscribe header of this message. If you cannot see it,
>>e-mail java-unsubscribe@stripped 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 <mysql-thread113212@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread