c 代码获取mysql时间间隔

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

int main() {
    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;
    char query[256];
    struct tm start_time, end_time;
    time_t start_tt, end_tt;
    double seconds_diff;

    // 初始化MySQL连接
    conn = mysql_init(NULL);
    if (!mysql_real_connect(conn, "localhost", "user", "password", "database", 0, NULL, 0)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }

    // 执行SQL查询
    strcpy(query, "SELECT start_time, end_time FROM time_table WHERE id = 1");
    if (mysql_query(conn, query)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }

    // 获取查询结果
    res = mysql_use_result(conn);
    if ((row = mysql_fetch_row(res)) != NULL) {
        sscanf(row[0], "%d-%d-%d %d:%d:%d", &start_time.tm_year, &start_time.tm_mon, &start_time.tm_mday,
               &start_time.tm_hour, &start_time.tm_min, &start_time.tm_sec);
        sscanf(row[1], "%d-%d-%d %d:%d:%d", &end_time.tm_year, &end_time.tm_mon, &end_time.tm_mday,
               &end_time.tm_hour, &end_time.tm_min, &end_time.tm_sec);

        start_tt = mktime(&start_time);
        end_tt = mktime(&end_time);

        seconds_diff = difftime(end_tt, start_tt);
        printf("Time interval: %.2f seconds\n", seconds_diff);
    }

    // 清理资源
    mysql_free_result(res);
    mysql_close(conn);

    return 0;
}