暂无个人介绍
-------------------------
-------------------------
-------------------------
-------------------------
-------------------------
-------------------------
-------------------------
#include <mysql/mysql.h>
#include <stdio.h>
#include <unistd.h>
#include <time.h>
int main(void) {
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;
/* Change me */
char *server = "rdsql.rds.aliyuncs.com";
char *user = "userXXX";
char *password = "XXXXX";
char *database = "XXXX";
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);
}
struct timeval start, end;
long secs_used,micros_used;
gettimeofday(&start, NULL);
char *sql_cmd = "SELECT * FROM user where id=11";
/* send SQL query */
if (mysql_query(conn, sql_cmd)) {
fprintf(stderr, "%s\n", mysql_error(conn));
exit(1);
}
gettimeofday(&end, NULL);
printf("start: %d secs, %d usecs\n",start.tv_sec,start.tv_usec);
printf("end: %d secs, %d usecs\n",end.tv_sec,end.tv_usec);
secs_used=(end.tv_sec - start.tv_sec); //avoid overflow by subtracting first
micros_used= ((secs_used*1000000) + end.tv_usec) - (start.tv_usec);
printf("Execute SQL %s micros_used: %d\n",sql_cmd, micros_used);
res = mysql_use_result(conn);
int num_fields = mysql_num_fields(res);
/* output table name */
printf("Result of %s is :\n", sql_cmd);
while ((row = mysql_fetch_row(res)) != NULL) {
int i;
for (i = 0; i < num_fields; i++) {
printf("%s ", row ? row : "NULL");
}
printf("\n");
}
/* close connection */
mysql_free_result(res);
mysql_close(conn);
return 0;
}
-------------------------
-------------------------
-------------------------
-------------------------
-------------------------