MySQL is ANSI 88 compliant, so they claim. As far as ANSI 92, they mislead by saying they "Follow ANSI SQL 92 requirements"
Jon
-----Original Message-----
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: MySQL versus Oracle
> It uses more or less standard SQL
It's still far from ANSI compliant. The biggest criticism/complaint from the
user community is the lack of subqueries (or "subselects" in MySQL jargon).
They say it's the highest priority enhancement. They said it would be
implemented in version 3.5X. Then they said it would be in 4.0 which is not
ready for production until this fall and will be almost a year behind
schedule. Now they're saying it will be in 4.1 which at this rate will be
the end of next year. Meanwhile, their manual states that they plan to be
ANSI92 and ANSI99 compliant but they don't give any dates. But it's the
fastest growing database so someday they may be standards compliant.
-----Original Message-----
Sent: Friday, May 31, 2002 10:41 AM
To: Multiple recipients of list ORACLE-L
I read few articles in Linux magazine and had it installed on
my box for a while and here are my impressions:
a) It's blindingly fast as a single user database, faster then oracle.
b) It uses more or less standard SQL minus all the unnecessary functions
like substr, decode, nvl and alike which nobody ever uses anyway (evil
grin).
c) It's small. You can have both software and a small database within 150M
d) I didn't learn how to do recovery. It doesn't have hot backups. You have
to
shut it down to make a sensible backup.
e) It's easy to configure and doesn't have too many things to set up.
Allegedly, the present version (I did my dirty work back in August 2001) can
use Perl as a scripting language, I don't know whether DBI/DBD is needed for
that and it can cope with committs and rollbacks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
