Mysql Compiling fejl

Jeg bruger en kode jeg har fundet her på Eksperten (lavet af arne_v). Jeg har dog også brugt andre koder, som alle giver samme fejl.
Koden ser således ud:

#include <windows.h>
#include <iostream>
#include <mysql.h>
#include <stdio.h>
#include <stdlib.h>

int main()
{
    MYSQL *handle;
    MYSQL_RES *result;
    MYSQL_ROW row;
    int nfields;
    int *l;
    int i;
    handle= mysql_init(NULL);
    if(handle == NULL)
    {
        printf("MySQL error: %s", mysql_error(handle));
        exit(1);
    }
    if(!mysql_real_connect(handle, "localhost", "root", "lol", "bjarke", 0, NULL, 0))
    {
        printf("MySQL error: %s", mysql_error(handle));
        exit(1);
    }
    mysql_query(handle, "SELECT * FROM test");
    result = mysql_store_result(handle);
    nfields = mysql_num_fields(result);
    while ((row = mysql_fetch_row(result))) {
        l = (int *)mysql_fetch_lengths(result);
        for (i=0; i<nfields; i++) {
            printf(" %.*s", l[i], row[i] ? row[i] : "NULL");
        }
        printf("\n");
    }
    mysql_free_result(result);
    mysql_close(handle);
    return 0;
}

Det min compiler så svare er:
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_close@4
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_free_result@4
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_fetch_lengths@4
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_fetch_row@4
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_num_fields@4
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_store_result@4
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_query@8
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_real_connect@32
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_error@4
example1_mysql.obj : error LNK2001: unresolved external symbol _mysql_init@4
Debug/example1_mysql.exe : fatal error LNK1120: 10 unresolved externals
Error executing link.exe.

example1_mysql.exe - 11 error(s), 0 warning(s)

Håber i kan hjælpe

//Bjarke