connect to server and execute multiple commands

This was my previous question:

Can someone give me simple example in C, of using pipe() system call to and use ssh to connect to a开发者_开发问答 remote server and execute a simple ls command and parse the reply. Thanks in advance, [...]

I got an answer for that, but I need something more.

I would like to ask how to use a pipe and connect to a remote server using ssh, then open mysql and execute a simple query like SELECT * FROM tables;.

Thanks in advance!

Are you doing this for a challenge?, if yes that's cool because you are doing a hard thing to the end, if not derobert suggestion is the best solution in case you want to communicate with the MySQL server.