>From the MySQL website.
We try to make MySQL follow the ANSI SQL standard and the ODBC SQL standard,
but in some cases MySQL does some things differently:
-- is only a comment if followed by a white space. See section 5.4.7 `--' as
the Start of a Comment.
For VARCHAR columns, trailing spaces are removed when the value is stored.
See section G Known errors and design deficiencies in MySQL.
In some cases, CHAR columns are silently changed to VARCHAR columns. See
section 7.7.1 Silent Column Specification Changes.
Privileges for a table are not automatically revoked when you delete a
table. You must explicitly issue a REVOKE to revoke privileges for a table.
See section 7.34 GRANT and REVOKE Syntax.
NULL AND FALSE will evaluate to NULL and not to FALSE. This is because we
don't think it's good to have to evaluate a lot of extra conditions in this
MySQL is NOT SQL92 Compliant like SQL Server, Oracle, Interbase... please
also refer to a previous post that refers to MySQL's poor performance under
load. Postgres is closer to being SQL92 compliant than MySQL also.
jon
----- Original Message -----
From: "Douglas Knudsen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 12:13 PM
Subject: Re: [RE: Cheaper Alternative to SQL Server 2000]
>
>
> IIRC, MySQL uses standard SQL, that is it conforms to SQL standards,
> where M$, Oracle, etc.
> add to the standard. So, as long as your SQL is standard, the queries
> you have
> written should work.
>
>
>
>
> > My concern would be if I was going to run MySQL, how much
> >difference would there be with writing my queries and what not, to
> >accommodate to MySQL?
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
