宅男视频

XClose

Information Services Division

Menu

Calling MySQL from C

MySQL databases may be used by programs written in the C programming language on Socrates and Plato and on the IS Solaris workstations.are given in the MySQL manual.

The following example program (in file prog.c) should be compiled with this Unix command:

cc -I/usr/local/include/mysql prog.c -lmysqlclient -lsocket -lnsl -lm -lz

This program displays the second and third fields (numbered 1 and 2) of each row of table people in database ucabwww where field age is greater than 30:

#include <mysql.h>
#include <stdio.h>

int main() {
聽聽 MYSQL *conn;
聽聽 MYSQL_RES *res;
聽聽 MYSQL_ROW row;

聽聽 char *server = "mysql-server.ucl.ac.uk";
聽聽 char *user = "ucabwww";
聽聽 char *password = "secret";
聽聽 char *database = "ucabwww";
聽聽 
聽聽 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));
聽聽聽聽聽 return(0);
聽聽 }

聽聽 /* send SQL query */
聽聽 if (mysql_query(conn, "SELECT * FROM people WHERE age > 30")) {
聽聽聽聽聽 fprintf(stderr, "%s\n", mysql_error(conn));
聽聽聽聽聽 return(0);
聽聽 }

聽聽 res = mysql_use_result(conn);
聽聽 
聽聽 /* output fields 1 and 2 of each row */
聽聽 while ((row = mysql_fetch_row(res)) != NULL)
聽聽聽聽聽 printf("%s %s\n", row[1], row[2]);

聽聽 /* Release memory used to store results and close connection */
聽聽 mysql_free_result(res);
聽聽 mysql_close(conn);
}