Mysql and C Integration

I am having trouble on connecting my C program to mysql. I've done most of the research but seems its quite difficult. Can someone please help? the image below shows the error using the command I typed to compile the code.

Your answers are highly appreciated. BTW, I am a windows user.

It looks like your LD_LIBRARY_PATH isn't set. I believe you need that to be able to find the libraries required by the linker.