SQL History and Revisions

This section provides a quick introduction of SQL history and revisions. 3 major revisions have been published: SQL1 or SQl-86, SQL2 or SQL/92, and SQL3 or SQL:1999.

In 1970, Edgar F. Codd from IBM published the first paper on relational data base model: "A Relational Model of Data For Large Shared Data Banks".

In 1979, IBM produced the first relational database called System/R, and a language called Structured English Query Language (SEQUEL) to access the database. SEQUEL was later shortened to SQL (Structured Query Language). But the pronounccation was maintained, so today we still pronounce SQL as "sequel".

SQL has gone 3 major revisions and several minor revisions:

SQL1 - Also known as SQL-86. This was the first publication of SQL by ANSI in 1986. Two minor revisions were published on SQL1: SQL-87 and SQL-89.

SQL2 - Also known as SQL/92, SQL-92, ISO/IEC 9075:1992, ANSI X3.135-1992, or FIPS 127-2. This was a major revision of SQL in 1992.

SQL3 - Also known as SQL:1999. This was a major revision of SQL in 1999. Several minor revisions were published on SQL3: SQL:2003, SQL:2006 and SQL:2008.

Last update: 2015.

Table of Contents

 About This Book

Introduction of SQL

 What Is SQL?

SQL History and Revisions

 SQL and Database Terminologies

 MySQL Introduction and Installation

 Introduction of MySQL Programs

 Perl Programs and MySQL Servers

 PHP Programs and MySQL Servers

 Java Programs and MySQL Servers

 Datatypes and Data Literals

 Operations and Expressions

 Character Strings and Bit Strings

 Commonly Used Functions

 Table Column Types for Different Types of Values

 Using DDL to Create Tables and Indexes

 Using DML to Insert, Update and Delete Records

 Using SELECT to Query Database

 Transaction Management and Isolation Levels

 Locks Used in MySQL

 Defining and Calling Stored Procedures

 Variables, Loops and Cursors Used in Stored Procedures

 Outdated Tutorials

 References

 PDF Printing Version