Many of the clients in MySQL source distributions are written in
C, such as mysql,
mysqladmin, and mysqlshow.
If you are looking for examples that demonstrate how to use the C
API, take a look at those clients: Obtain a source distribution
and look in its
client directory. See
How to Get MySQL.
For information about individual C API functions, the sections for most functions include usage examples.