O'Reilly logo

MySQL, Second Edition: Visual Quickstart Guide by Larry Ullman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required