C - MySQL connection example ============================ Public domain ******************************************************************************** ### Example #include #include #include main() { MYSQL *conn; MYSQL_RES *res; MYSQL_ROW row; char *server = "localhost"; char *user = "root"; char *password = ""; char *database = "mysql"; conn = mysql_init(NULL); /* Connect to database */ if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) { fprintf(stderr, "%s\n", mysql_error(conn)); exit(1); } /* send SQL query */ if (mysql_query(conn, "show tables")) { fprintf(stderr, "%s\n", mysql_error(conn)); exit(1); } res = mysql_use_result(conn); /* output table name */ printf("MySQL Tables in mysql database:\n"); while ((row = mysql_fetch_row(res)) != NULL) printf("%s \n", row[0]); /* close connection */ mysql_free_result(res); mysql_close(conn); } ******************************************************************************** ### Compile # mysql_config --libs -rdynamic -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib/ -lssl -lcrypto # mysql_config --cflags -I/usr/include/mysql -DUNIV_LINUX -DUNIV_LINUX # gcc -o output-file $(mysql_config --cflags) mysql.c $(mysql_config --libs) ******************************************************************************** ### Links [http://www.cyberciti.biz/tips/linux-unix-connect-mysql-c-api-program.html](http://www.cyberciti.biz/tips/linux-unix-connect-mysql-c-api-program.html) [http://zetcode.com/tutorials/mysqlcapitutorial/](http://zetcode.com/tutorials/mysqlcapitutorial/) [http://dev.mysql.com/doc/refman/5.0/en/c.html](http://dev.mysql.com/doc/refman/5.0/en/c.html) ******************************************************************************** _BY: Pejman Moghadam_ _TAG: mysql, c_ _DATE: 2012-02-15 13:04:00_