#include <stdio.h>
#include <mysql/mysql.h>
int main() {
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;
conn = mysql_init(NULL);
if (conn == NULL) {
fprintf(stderr, "mysql_init() failed\n");
return 1;
}
if (mysql_real_connect(conn, "localhost", "username", "password", "database", 0, NULL, 0) == NULL) {
fprintf(stderr, "mysql_real_connect() failed\n");
mysql_close(conn);
return 1;
}
if (mysql_query(conn, "SELECT DATE_FORMAT(NOW(), '%Y%m') AS formatted_date")) {
fprintf(stderr, "SELECT query failed: %s\n", mysql_error(conn));
mysql_close(conn);
return 1;
}
res = mysql_store_result(conn);
if (res == NULL) {
fprintf(stderr, "mysql_store_result() failed\n");
mysql_close(conn);
return 1;
}
row = mysql_fetch_row(res);
if (row == NULL) {
fprintf(stderr, "mysql_fetch_row() failed\n");
mysql_free_result(res);
mysql_close(conn);
return 1;
}
printf("Formatted Date: %s\n", row[0]);
mysql_free_result(res);
mysql_close(conn);
return 0;
}