A Conversation for SQL databases
Standards
Stephen Booth aka Buffy Started conversation Jul 17, 2001
There is an ANSI (American National Standards Institute) standard for SQL. ANSI developed most of the standards for IT. The standard is referred to as the ANSI-92 SQL standard and has been adopted by ISO (International Standards Organisation).
Most major SQL databases use ANSI-92 standard SQL. MySQL is one of the few that doesn't implement it, the SQL that MySQL uses is compliant but not all compliant SQL will work with MySQL so MySQL is not an ANSI-92 complaint database. Microsoft Access and SQLServer prefer a Microsoft specific implementation and are not ANSI-92 compliant.
Examples of ANSI-92 compliant databases are Oracle and DB2.
Key: Complain about this post
Standards
More Conversations for SQL databases
Write an Entry
"The Hitchhiker's Guide to the Galaxy is a wholly remarkable book. It has been compiled and recompiled many times and under many different editorships. It contains contributions from countless numbers of travellers and researchers."