List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 27 2002 3:03pm
Subject:RE: SubQueries and Temp Tables
View as plain text  
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: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
>>
>>

Thread