Chapter 5. Introduction to MySQL Programming

In this part of the book, we'll discuss what you need to know to write your own programs that access MySQL databases. MySQL comes with a set of utility programs. For example, mysqldump exports the contents and structure definitions of tables, mysqlimport loads data files into tables, mysqladmin performs administrative operations, and mysql lets you interact with the server to execute arbitrary queries. Each of the standard MySQL utilities is intended as a small, focused program with a specific, limited function. This is true even for mysql, which is more flexible than the other utilities in the sense that you can use it to execute any number of different queries: It's designed with the single purpose ...

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.