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
