Gcc-g Mysqlquery.c-lmysqlclient-i/usr/include/mysql-l/usr/lib64/mysql
#include <stdlib.h>#include<stdio.h>#include<string.h>#include<mysql.h>#include<sys/time.h>intMain (intargcChar*argv[]) { if(ARGC <2) {printf ("a.out sql\n"); } MYSQL Conn; Mysql_init (&conn); if(! Mysql_real_connect (&conn,"192.168.49.189","Admin","Admin","obtest",2880Null0) {printf ("Connection failed\n"); return-1; } Charerror_info[1024x768] = {0}; Mysql_res* result =0; structTimeval t0,t1,t2; Gettimeofday (&t0,0); if(mysql_query (&conn, argv[1]) {strncpy (Error_info,mysql_error (&conn),1024x768); printf (error_info); Mysql_close (&conn); return-1; } result= Mysql_store_result (&conn); if(Result = =0) {strncpy (Error_info,mysql_error (&conn),1024x768); printf (error_info); Mysql_close (&conn); return-1; } intNum_fields =mysql_num_fields (Result); Mysql_row ROW; Gettimeofday (&T1,0); while(row =mysql_fetch_row (Result))) {unsignedLong*lengths =NULL; inti; for(i =0; i < Num_fields; i++) {printf ("%s\t", Row[i]?row[i]:"NULL"); } printf ("\ n"); } gettimeofday (&t2,0); Mysql_free_result (result); Mysql_close (&conn); Long Longdiff = t1.tv_sec-t0.tv_sec; Diff= diff *1000000+ (T1.tv_usec-t0.tv_usec); printf ("query takes time%llu\n", diff); Diff= T2.tv_sec-t0.tv_sec; Diff= diff *1000000+ (T2.tv_usec-t0.tv_usec); printf ("Query and output take time%llu\n", diff); return 0;}
MySQL C sample Program