Message-ID: <F001.00470E3D.20020531075326@fatcity.com>
Date: Fri, 31 May 2002 07:53:26 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Joe Raube <jraube@yahoo.com>
Subject: Re: MySQL versus Oracle
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I've seen MySQL truncate data on insert without warning.

MySQL also does not have foreign keys. It accepts the syntax of
create foreign key, but nothing is created, nothing is enforced.

I recently did a migration from MySQL to Oracle, and these were the
two major issues I faced.

Let me know if you have any more specific questions.

-Joe

--- Joe Testa <jtesta@dmc-it.com> wrote:
> Anyone on the list done a comparison(or worked with both) MySQL and
> 
> Oracle and can give me the good/bad points of My SQL?
> 
> Doing interviewer thing and someone has My SQL who would like to
> move 
> into the oracle world and i know nothing about mySQL and am
> wondering if 
> the transition from one to the other is easily done.
> 
> thanks, joe


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: jraube@yahoo.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@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).