如何通过代码:::Blocks中的静态链接创建独立程序

I want to run my program standalone. It is simple connection to MySQL using libmysql.lib and requires libmysql.dll in order to run (have it in same folder). Now my question is, how could i compile in c::b so I can use my executable on other machine and will not require .dll? I heard about static libraries but I have no idea how it works, so would be really nice if someone could explain me the process.I want to run my program standalone. It is simp