2. Using SQL to Manage Data
Structured Query Language (SQL) is the language that the MySQL server understands and is the means by which you tell the server how to perform data management operations. Therefore, fluency with SQL is necessary for effective communication with the server. When you use a program such as the mysql client, it functions primarily as a way for you to send SQL statements to the server to be executed. If you write programs in a language that has a MySQL interface, such as the Perl DBI module or PHP PDO extension, these interfaces enable you to communicate with the server by issuing SQL statements.
Chapter 1, “Getting Started with MySQL,” presents a tutorial introduction to many of MySQL’s capabilities, including some basic ...
Get MySQL® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
