How to connect and insert record to mysql using c language?

Hello friends,

My question is, can i connect mysql with c language? And if connection is possible so how to insert record to mysql database. Please give simple and small example.

If any query so comment please.