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