MySQL

$ sudo apt-get install libmysqlclient-dev

$ gcc -o output-file  $(mysql_config --cflags) mysql-c-api.c  $(mysql_config --libs)


여기에서 mysql-connector-c-6.0.2-win32.msi 파일을 다운 받아 설치한다.

C:\Program Files\MySQL\MySQL Connector C 6.0.2\include
C:\Program Files\MySQL\MySQL Connector C 6.0.2\lib\opt

전체 설치를 하면 설치 디렉토리에 libmysql.dll 파일도 설치된다.

mysql_init()
mysql_real_connect()
mysql_close()
mysql_query()
mysql_store_result()
mysql_free_result()
mysql_fetch_row()

#define SOCKET int
#include <mysql.h>

#pragma comment(lib, "libmysql.lib")

int main(int argc, char* argv[])
{
// {
    int nRet = 1;

    MYSQL conn;
    int query_stat;

    mysql_init(&conn);

    // DB 연결
    MYSQL *connection = mysql_real_connect(&conn, "localhost",
        "user_id", "user_pass", "my_db", 3306, (char *)NULL, 0);
    if (NULL == connection) {
        fprintf(stderr, "Mysql connection error : %s", mysql_error(&conn));
        goto exit_here;
    }

    MYSQL_RES *sql_result;
    MYSQL_ROW sql_row;

    query_stat = mysql_query(connection, "select field1, field2 from my_tb");
    if (0 != query_stat) {
        fprintf(stderr, "Mysql query error : %s", mysql_error(&conn));
        goto exit_here;
    }

    sql_result = mysql_store_result(connection);

    while ( NULL != (sql_row = mysql_fetch_row(sql_result)) ) {
        printf("field1(%s), field2(%s)\n",sql_row[0], sql_row[1]);
    }

    mysql_free_result(sql_result);

    nRet = 0;

exit_here:
    if (NULL != connection)
        mysql_close(connection);
// }
//    printf("Hello World!\n");
    return nRet;
//    return 0;
}

참조 사이트:

http://dev.mysql.com/doc/refman/5.1/en/threaded-clients.html
http://superkkt.com/234

http://www.cyberciti.biz/tips/linux-unix-connect-mysql-c-api-program.html

http://blog.jidolstar.com/250
http://dev.mysql.com/downloads/connector/
http://dev.mysql.com/doc/refman/5.1/en/connectors-apis.html
http://tangentsoft.net/mysql++/
http://www.devpia.com/MAEUL/Contents/Detail.aspx?BoardID=51&MAEULNo=20&no=6874&ref=6874