RE: Oracle vs. MySQL

You can't do subqueries in mySQL
You can't use derived tables in mySQL
The foreign key support is defined as not being "Full", don't know what that means.

Dave

-----Original Message-----
Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L

The comparisons look good for MySQL...
not bad for others, but better for
mySQL than some comments by some
folks on the list would have led me
to believe.

Anyone here have major gripes about
mySQL that oracle solved?

-----Original Message-----
Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L

Interesting site...

Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old.

> -----Original Message-----
> From: Dwayne Cox [mailto:dwaynec_at_infotechfl.com]
> Sent: Wednesday, August 01, 2001 9:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: off topic--oracle Vs ms sql
>
>
> Try this site...
>
> http://www.mysql.com/information/crash-me.php
>
> On Mon, 30 Jul 2001 13:29:28 -0800
> "Ravindra Basavaraja" <ravindra_at_sentica.com> wrote:
>
> > Does anyone have any doc or links that compares oracle and ms sql.
> >
> > Also what are the equivalent data types in ms sql for oracle's lobs.
> >
> > Thanks
> > Ravindra
>
>
> __________________________________________________________________
> Dwayne Cox
> DBA, Development Dept.
> Info Tech, Inc.
> dwaynec_at_infotechfl.com
> http://www.infotechfl.com
> ___________________________________________________________________
> The opinions expressed are the author's own unless otherwise stated
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dwayne Cox
> INET: dwaynec_at_infotechfl.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  INET: Bruce.Page_at_BellSouth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).