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
