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 O’Reilly online learning.

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