How to link static library C::B

[JihadMossad]

Hello everyone, I have headaches for 3 days already figuring out how to create standalone program. For now I have simple program connecting to MySql Database and when i run it, shows me error, libmysql.dll is missing... When i put libmysql.dll in same folder works. Now my question is, how in code blocks can i compile so i won't require libmysql.dll anymore and be able to use it on any machine. Thanks for all answers in advance!

[modoran]

Add already compiled as static library "libmysql.a" to linker input.