MySQL, Second Edition: Visual Quickstart Guide

5. Basic SQL

SQL, short for Structured Query Language (although this is sometimes debated), is a group of special words used exclusively for interacting with databases. Every major database uses SQL, and MySQL is no exception.

SQL was created shortly after E.F. Codd came up with the theory of a relational database (along with normalization). Decades later, in 1989, the American National Standards Institute (ANSI)—the organization responsible for maintaining the language—released the first SQL standard, referred to now as SQL 89. SQL2 was released in 1992. In 1999, SQL 3 was released, although it has not been completely supported as yet. And in 2003, a new standard was defined, with increased XML support.

Using the accounting database created ...