Chapter 3. MySQL SQL Syntax and Use

Fluency with SQL is necessary in order to communicate with the MySQL server. For example, when you use a program such as the mysql client, it functions primarily as a means for you to send SQL statements to the server to be executed. But you must also know SQL if you write programs that use the MySQL interface provided by your programming language because you'll still communicate with the server by sending SQL statements to it.

Chapter 1, "Introduction to MySQL and SQL," presented a tutorial introduction to many of MySQL's capabilities. This chapter builds on that material to go into more detail on several areas of SQL implemented by MySQL. It discusses how to refer to elements of databases, including the ...

Get MySQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.